which performance is better while excluding values in set analysis?

[#1]

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

[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]

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...