Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 - Specialist
Partner - Specialist

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)))