Set analysis to count over multiple field values

[sifatnabil]

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?

[tresesco]

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.

[senpradip007]

Try this:

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

[sifatnabil]

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.

[sifatnabil · Accepted solution]

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