Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Mt3
Contributor III
Contributor III

Exclusion <> not working on string values, graph

Hi,

Below attempt was aimed into counting Spec IDs only if they are different than All IDs. 

Going through the Qlik forum I found out that not in  or != can be replaced by <>. 

Unfortunately, the <> did not do its job. Is there any other solution you would suggest?

Its a graph formula, not the script one.

count (if (([All IDs] <> [Spec IDs]), [Spec IDs]))

Labels (4)
1 Reply
Digvijay_Singh

Pl share a sample app to understand the problem, expression looks okay to me, I assume both All IDs and SPec IDs fields are in the same table. Also check if you need distinct count.