Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have selections list boxes which shows e.g. all available departments of employees.
What I am looking for is a possibility that when a department is not in use in selected Year/Month, this department will be hide instead of a gray colored right now.
Do somebody know how to provide this ?
Thanks
Use "Hide Excluded" in the List Box Properties (first tab).
Regards,
Florian
hi
see this link hope this helps you to solve your problem
http://qlikviewnotes.blogspot.in/2012/01/power-of-gray.html
http://community.qlik.com/thread/52670
see attachement..
Regards
Thanks and almost what I am looking for Now are the values indeed hided, but the rows are still in the list.
e.g.
1
gray colored row
3
Do you know how to provide
1
3 ?
Instead of a listbox try using a table box and format it like a listbox.
Hope that helps ...
Hi , try this
=Aggr(Only({<fieldname=>}fieldname),fieldname)
Or
=Aggr(Only(fieldname),fieldname)
this will filter the values depending on the year/ month selected and u will not see the gray data..