get available items from list

[#1]

Hello,

I am using qlikview 11.

I have a field fld1 with values as val1, val2, val3.

At some particular selection only val3 is enabled and val1 and val2 are disabled.

Still I want to get val1, val2 and val3.

I have used below expression in variable but getting only the possible available items.

=Concat(fld1, ',')

[MayilVahanan · Accepted solution]

Hi

Try like this

=Concat({1}fld1, ',')

Edit:

{1} - ignore all the selections

=Concat({<fld1=>}fld1, ',') ignore fld1 selection alone.

hope it helps

[tresesco]

=Concat({1} fld1, ',')            // '{1}' ignores the selection

[#4]

yes it is working.

Thanks a lot.

[#5]

Hi,

also can we get the count of Concat({1}fld1, ',')

[MayilVahanan]

Hi

Try like this

=Count({1}distinct fld1) - to get the count of distinct fld1 values which exclude the selection.