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: 
Mayank3
Contributor
Contributor

Issue with Qlik Logic

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

 

1 Solution

Accepted Solutions
rwunderlich
MVP
MVP

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

View solution in original post

2 Replies
rwunderlich
MVP
MVP

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

Kaushik2020
Creator III
Creator III

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