Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

which performance is better while excluding values in set analysis?

I have below data

Points:

LOAD * INLINE [

    Country, Points

    India, 10

    India, 11

    UK, 12

    UK, 9

    USA, 10

    USA, 89

];

I want to aggregate points for all countries except India:

Dimension: Country

Exp1: sum({Country-={'India'} Points)

Exp2: sum({Country={*}-{'India'} Points)

If we many columns in a table and using Exp1 and Exp2 methods to exclude any value, which method performs better than that of other. Is it Exp1 or Exp2 method?

-Regards

Ramesh

Labels (1)
3 Replies
sunny_talwar

As per my understanding there won't be any performance difference because Exp1 is another way of writing Exp2.

Note: This is as per my limited experience with QlikView. Experts, please feel free to disagree with me.

Best,

Sunny

stigchel
Partner - Master
Partner - Master

I'm also not sure about performance, but I do think there is a slight difference in meaning that depends on where you put the - sign, so -= or =-.

remove FieldA  A strings from the current set:

=Count({<FieldA-={"A"}>} FieldA)

or select the set where FieldA does not contain A

=Count({<FieldA=-{"A"}>} FieldA)

sunny_talwar

‌good eye Piet...