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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
Partner Ambassador/MVP
Partner Ambassador/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
Partner Ambassador/MVP
Partner Ambassador/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