Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
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.