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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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