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: 
anonymous1
Contributor III
Contributor III

set analysis to ignore selection

hi ,

im trying to write a set analysis expression to count all the items at a site, regardless of selections made.  i cant seem to get my expression correct:

if ([SITE_TYPE]='Site',count({1}ITEM))

when i make another selection the graph changes, can anyone see what im doing wrong?

Labels (1)
1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

Hi,

Try with

=count({1<SITE_TYPE={"Site"}>} ITEM)

View solution in original post

1 Reply
sergio0592
Specialist III
Specialist III

Hi,

Try with

=count({1<SITE_TYPE={"Site"}>} ITEM)