topic list box conditional view in QlikView

list box conditional view

Tue, 06 Aug 2013 10:54:58 GMT

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

Re: list box conditional view

pennetzdorfer — Tue, 06 Aug 2013 10:59:05 GMT

Use "Hide Excluded" in the List Box Properties (first tab).

Regards,

Florian

Re: list box conditional view

Tue, 06 Aug 2013 11:03:51 GMT

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

Re: list box conditional view

Tue, 06 Aug 2013 11:55:50 GMT

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 ?

Re: list box conditional view

pennetzdorfer — Tue, 06 Aug 2013 12:45:16 GMT

Instead of a listbox try using a table box and format it like a listbox.

Hope that helps ...

Re: list box conditional view

shree909 — Tue, 06 Aug 2013 13:28:38 GMT

Hi , try this

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

=Aggr(Only(fieldname),fieldname)

this will filter the values depending on the year/ month selected and u will not see the gray data..