Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Hide non selected checkboxes

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.

checkboxesdesktop.PNG.png

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

checkbox accesspoint.PNG.png

Can I hide those checkboxes?

Regards,

Kris

9 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Hi,

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

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

Checkbox.PNG.png

Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
Not applicable

try:

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

Regards

Rahul

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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.

Checkbox1.PNG.png

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

Checkbox2.PNG.png

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

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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.

Checkbox3.PNG.png

Not applicable

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

Aggr(Only((Field_Name)),Field_Name)


Regards


R