topic Re: which performance is better while excluding values in set analysis? in Scalability

which performance is better while excluding values in set analysis?

Wed, 17 Jun 2015 12:14:41 GMT

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

Re: which performance is better while excluding values in set analysis?

sunny_talwar — Wed, 17 Jun 2015 12:18:26 GMT

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

Re: which performance is better while excluding values in set analysis?

stigchel — Wed, 17 Jun 2015 12:42:20 GMT

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)

Re: which performance is better while excluding values in set analysis?

sunny_talwar — Wed, 17 Jun 2015 12:45:58 GMT

‌good eye Piet...