Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
HD90
Contributor
Contributor

Filter Selection based on Condition

Hi team,

I have filter, In that i have some values.

Eg:

A

B

C

D

if I select A and B its to display sum(Sales)

If I select A and B and C etc its to display count(Sales)

For Particular Selection, I need to show one measure,

If extra anyone Value is added in the filter it should show other measure...

 

Thanks in Advance

 

2 Replies
Clement15
Partner - Creator III
Partner - Creator III

Hello, could this function be useful to you?

GetFieldSelections | QlikView Help

anat
Master
Master

if(GetFieldSelections(field)='A, B',sum(sales),

if(GetFieldSelections(field)='A, B, C',Count(sales)))