Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Passing arguments in count function?

Hey,

I have following expression,

=count(DISTINCT SUBGROUP)

But i want the count for only a particular company for example COMPANY='XYZ'

please help.

Thanks.

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

=count({<COMPANY={'XYZ'}>}DISTINCT SUBGROUP)

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

=count({<COMPANY={'XYZ'}>}DISTINCT SUBGROUP)

View solution in original post

Highlighted
Master III
Master III

Abhi , has given you the best way to do this. On the other hand you want the value passed to be dynamic means based on selection you can use variable as

vSelected=getfieldselected(COMPANY)

=count({<COMPANY=(=$(vSelected))>}DISTINCT SUBGROUP)

Highlighted
Creator III
Creator III

Hey Thanks..