Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm having problems with scripting a set analysis and I noticed when I look up the correct syntax to use in qlik... it's changed on the resource site? For instance, I'm trying to use a "not equal" scripting syntax for a set analysis on version 3.2 SR4 which I thought was
"-=" (it executes). However, because I was having issues with operators not executing as written, I looked up the scripting syntax and now see that for 3.2 "not equal" is written as "!=" (which doesn't execute)...
Does someone know the correct way to write:
[field1] "not equal" $(variable1) and,
[field2] "not equal" $(variable2) and,
[field3] = $(variable3)
[field1] <> $(variable1) and
[field2] <> $(variable2) and
[field3] = $(variable3)
Not sure but I think you are looking at the wrong place. This documentation looks like for the security rules design in QMC administration. I think its not related to set analysis expression design.
yes its qmc qliksense
if you are looking in script you can try this
Where not Match([Seller Type], 'SIG MM', 'SIG SM', 'CST');
The syntax for not equal in Set Analysis is: Note the minus comes after =.
{<[field1] =- $(variable1)>}
A minus before the = means "remove this value from the current selections".
{<[field1] -= $(variable1)>}
There is a subtle difference. In the clear state, they may return the same results if there are no nulls. If selections have been made in the field, they will return different results.
Another set modifier syntax for not equals is:
{<[field1] = "<>$(variable1)">}
I believe that will always return the same results as =-
-Rob