Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Different results in set analysis

I am using a set analysis statement like the following in a QlikView document.

I am finding that if there are NO records where [Scope State] has a non-null value, then I get the entire list of records, where I would expect NO records returned.

However, if I have at least 1 record where [Scope State] has a non-null value, then I get just the records I would expect, records where [Scope State] is set to a non-null value.

Any ideas on this?

 

=Concat({<[Scope State] = {"*"} >}[Scope Name], '    ')

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Hey Fred,

You may want to filter out null values in your load script, or at least flag them like this:

if(isnull([Scope State]),0,[Scope State]) as [Scope State]

Then in your set analysis use

=Concat({<[Scope State] -= {0} >}[Scope Name], '    ')

Your statement is showing different results because when there are no values in Scope State, Qlikview doesn't have anything to select in your set analysis so it doesn't filter on anything.

Does this help you?

View solution in original post

2 Replies
Highlighted
Creator II
Creator II

Hey Fred,

You may want to filter out null values in your load script, or at least flag them like this:

if(isnull([Scope State]),0,[Scope State]) as [Scope State]

Then in your set analysis use

=Concat({<[Scope State] -= {0} >}[Scope Name], '    ')

Your statement is showing different results because when there are no values in Scope State, Qlikview doesn't have anything to select in your set analysis so it doesn't filter on anything.

Does this help you?

View solution in original post

Highlighted
Not applicable

Thanks Napac1458,

Your answer clarifies why I was getting the strange results.  And I was able to implement a solution based on your code sample.  So thank you very much.

Fred