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: 
Applicable88
Creator III
Creator III

Subsets in Set analysis within same dimension

Hello,

what is the purpose of this:

count(distinct{$<Status-={"*AAAA*","*AAAB*"}>*$<Status={"*Open*"}>}Orders)
 
I mean the * sign . As I can see it you have two filters on "status"  and the first one is actually already closed with angled brackets.
can you reopen the same dimension only with * , or what does that mean?
 
Thank you in advance.
 
Best.
1 Solution

Accepted Solutions
SerhanKaraer
Creator III
Creator III

Hi Applicable,

Asterisk in the set analysis is the intersection operator.

Here is a cheat sheet for set analysis:

https://aftersync.com/blog/the-qlikview-set-analysis-cheat-sheet

View solution in original post

1 Reply
SerhanKaraer
Creator III
Creator III

Hi Applicable,

Asterisk in the set analysis is the intersection operator.

Here is a cheat sheet for set analysis:

https://aftersync.com/blog/the-qlikview-set-analysis-cheat-sheet