topic Re: get available items from list in QlikView

get available items from list

Mon, 15 Sep 2014 07:11:51 GMT

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 — Mon, 15 Sep 2014 07:13:43 GMT

Try like this

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

Edit:

{1} - ignore all the selections

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

hope it helps

tresB — Mon, 15 Sep 2014 07:14:39 GMT

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

Mon, 15 Sep 2014 08:34:52 GMT

yes it is working.

Thanks a lot.

Mon, 15 Sep 2014 10:06:05 GMT

Hi,

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

MayilVahanan — Mon, 15 Sep 2014 10:10:20 GMT

Try like this

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