Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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.