syntax on alternate state to exclude some value

[ronaldwang]

I have a field named activity and the distinct value in the field is null, 1, 2, 3 and I have assigned a list box of this filed as alternate state “Activity”.

If in the expression I want to calculate the sum of amount but putting a filter on activity where the field value will not equal to 2 (or in other words, should including null, 1, 3). What is the best syntax I should be using? thanks

[Anil_Babu_Samineni · Accepted solution]

Create one Alternate State let's assume AS01. Then Try this?

Count({AS01<Activity -= {2}>} DISTINCT Value)

[qlik4asif]

What is the use of alternate state here

Any how Count({<Activity -= {2}>} DISTINCT Value)  will exclude activity 2.