set analysis to ignore selection

anonymous1 — Sat, 16 Nov 2024 03:01:55 GMT

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?

Re: set analysis to ignore selection

sergio0592 — Thu, 11 Jul 2019 13:47:53 GMT

Hi,

Try with

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

topic set analysis to ignore selection in QlikView

set analysis to ignore selection

Re: set analysis to ignore selection