Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me out on below senario.
[Col A], [Col B] = {1} so what does it mean
A. Col A = 1 & Col B = 1
B. Col B = 1
C. Col A = 1 or Col B = 1
or something else
By itself, it would be invalid syntax. As a set modifier enclosed in angle brackets like this:
<[Col A], [Col B] = {1}>
it would mean "ignore any selections made in [Col A] and select value '1' in [Col B]"
-Rob
By itself, it would be invalid syntax. As a set modifier enclosed in angle brackets like this:
<[Col A], [Col B] = {1}>
it would mean "ignore any selections made in [Col A] and select value '1' in [Col B]"
-Rob
The expression [Col A], [Col B] = {1} in Qlik typically means: C. Col A = 1 or Col B = 1
In Qlik, when you write a set like: [Col A], [Col B] = {1}
…it is interpreted as: Select rows where either [Col A] = 1 OR [Col B] = 1
This is because the syntax is applying the same value {1} to both fields independently, and Qlik evaluates it like: ([Col A] = 1) OR ([Col B] = 1)
Conclusion - ✅ C. Col A = 1 or Col B = 1