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: 
Anonymous
Not applicable

Get selected count

Hai,

sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)

can anyone explain how does it works..what is the result of this.

Thanks in advance

10 Replies
sravanthialuval
Creator
Creator

Hi,

It will work based on 4 cases:

1. if you select only month  filter result is true and display qty.

2. if you select month and day, result will be true and display qty.

3.if you select month,day and year result will false and display mnth_qty.

4.Even if you not select any filter, result will be true and display  qty.