Visokio website     Downloads     Video tutorials     KnowledgeBase  
Named Query exclude NULLS - Visokio Forums
Named Query exclude NULLS
  •     Mees February 1, 2011 5:38AM
    Often we create named queries that filter out the 'no values'.
    Example: one of the fields is Product. The dataset contains 10 productvalues, but also records without a productvalue (the no values). My views only need records with a productvalue, so we use Named Queries. When creating the Query we deselect the 'no value' in the fieldfilter and save the Named Query.

    Now we get new sourcedata and new productvalues are added to the dataset. The Named Query doesn't work as expected as it only contains the productvalues of the previous dataset where we expected it would leave out NULLS but include new products.

    Please advice how to do this as we now have to clear the named query and populate it again after each new refresh.
    Thanks
  • 2 Comments
  •     steve February 1, 2011 5:57AM
    See here:
    http://forums.visokio.com/discussion/587

    In short, checkbox filters are by inclusion of values, rather than exclusion.

    To create an exclusion rule, select the null value in a view (e.g. bar view) and click Move, then create a named query.
  •     Mees February 1, 2011 8:54AM
    Thanks will try

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership