topic Passing arguments in count function? in QlikView

Passing arguments in count function?

rohitians — Fri, 20 Feb 2015 05:45:25 GMT

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.

Re: Passing arguments in count function?

AbhijitBansode — Fri, 20 Feb 2015 05:47:29 GMT

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

Re: Passing arguments in count function?

sujeetsingh — Fri, 20 Feb 2015 05:53:15 GMT

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)

Re: Passing arguments in count function?

rohitians — Fri, 20 Feb 2015 05:56:50 GMT

Hey Thanks..