topic Re: Set analysis to count over multiple field values in QlikView

Set analysis to count over multiple field values

sifatnabil — Wed, 14 May 2014 04:21:27 GMT

Hi all,

I wish to use set analysis to count distinct values of a field when multiple values in another field are selected. So I created a variable vRecordType=GetFieldSelections([Record Type]), and then in the set analysis wrote this:

=count(distinct {<Market=,[Record Type]={'$(vRecordType'}>} loginname)

This works when only 1 value is selected in [Record Type] - however it shows 0 when multiple values in [Record Type] are selected. How can I count over multiple values in this field?

Re: Set analysis to count over multiple field values

tresB — Wed, 14 May 2014 04:34:44 GMT

If you want the [Record Type] field selection to be considered as it is selected, you don't have to include that in Set Analysis part, QV does it so by default. Try like:

count( {<Market=>} distinct loginname) // this will ignore Market selection.

Re: Set analysis to count over multiple field values

senpradip007 — Wed, 14 May 2014 04:34:46 GMT

Try this:

=count(distinct {<Market=,[Record Type]={"$(=Concat(Chr(39)& [Record Type] & Chr(39), ','))"} >} loginname)

Re: Set analysis to count over multiple field values

sifatnabil — Wed, 14 May 2014 05:40:52 GMT

Hi tresesco, in my case the [Record Type] field is not selected, but has the associated fields in white (after I select something in Market). How can I count the non-selected associated values of [Record Type]? Thanks.

Re: Set analysis to count over multiple field values

sifatnabil — Wed, 14 May 2014 05:53:15 GMT

Nevermind. Looked through the forums and found it can be done with [Record Type]=P[Record Type]. Thanks!