topic Hide non selected checkboxes in QlikView

Hide non selected checkboxes

kris_vliegen — Thu, 12 Jun 2014 10:29:56 GMT

Hello,

I've a little question about checkboxes.

I've implemented them in my dashboard. And in my desk-top version, the non-selected items deissapear and also the checkboxes.

If I look in the accespoint to the dashboard the items dissapear but the checkboxes don't hide.

Can I hide those checkboxes?

Regards,

Kris

Re: Hide non selected checkboxes

Gysbert_Wassenaar — Thu, 12 Jun 2014 10:38:43 GMT

Perhaps by changing the field to an expression: aggr(Artikelomschrijving, Artikelomschrijving)

Re: Hide non selected checkboxes

kris_vliegen — Thu, 12 Jun 2014 11:11:36 GMT

If I do that, Nothing shows up in my list box...

Re: Hide non selected checkboxes

Gysbert_Wassenaar — Thu, 12 Jun 2014 13:14:08 GMT

Then maybe the field name isn't Artikelomschrijving. Qlikview is case sensitive so you need to use exact case sensitive field names.

Or did you try to enter an expression on the Expressions tab? I meant selecting the option <Expression> in the Field dropdown box on the General tab. If you select that then Expression Editor will open and you can enter an expression that generates the values for the listbox.

Re: Hide non selected checkboxes

kris_vliegen — Thu, 12 Jun 2014 13:23:42 GMT

Hi,

If I use an expression I don't get anny item.

The fieldname that I use in the List Box is ArtikelomschrijvingNed.

Re: Hide non selected checkboxes

Gysbert_Wassenaar — Thu, 12 Jun 2014 13:31:11 GMT

Is it possible that there are no possible values for ArtikelomschrijvingNed due to the selections you made in the other fields? Do you see any white value if you use ArtikelomschrijvingNed as field in a listbox or are all values grey?

Re: Hide non selected checkboxes

Thu, 12 Jun 2014 13:37:24 GMT

try:

Aggr(Only({<Field_Name=>}(Field_Name)),Field_Name)

Regards

Rahul

Re: Hide non selected checkboxes

kris_vliegen — Thu, 12 Jun 2014 13:51:29 GMT

Actually my question is, why is there a difference between what I see in My Desktop and in the accesspoit.

In my Desktop-version I have ony checkboxes for the possible values.

And in my accesspoint I also see checkboxes for the non-possible values.

I would like to see in the access-point the same as in the desktopversion.

Re: Hide non selected checkboxes

kris_vliegen — Thu, 12 Jun 2014 14:10:41 GMT

Thank you Rahul. It's a nice solution to make the listbox just als long as there are values.

Only, if I select one value. in the dashboard in the accesspoint, the values are hidden but the checkboxes did not hide.

Re: Hide non selected checkboxes

Thu, 12 Jun 2014 14:41:41 GMT

if that's the result you are after go for:

Aggr(Only((Field_Name)),Field_Name)

Regards