topic Hide Filters if they contain null values in QlikView

Hide Filters if they contain null values

Fri, 01 Mar 2013 11:35:59 GMT

Hi,

Im building a dashboard from a large dataset. I have 10 data fields (filter1, filter2.....filter10) - which are used to populate List Boxes within the document.Some of these fields will be empty depending on the selections made.

All of the listboxes are currently in a container. Is there a way to hide these filters if the field is empty??

Many thanks for your help,

Fiorano

Re: Hide Filters if they contain null values

nirav_bhimani — Fri, 01 Mar 2013 11:42:30 GMT

Hi,

You can do this in the script level,Syntax is as follow.

where len("ColumnName")<> 0;

Regards,

Nirav Bhimani

Re: Hide Filters if they contain null values

alexandros17 — Fri, 01 Mar 2013 11:45:26 GMT

in presentation tab of the object set the show property to

GetPossibleCount(xxxxx) where xxxxx is the field you are displayng in the filter

In this way if there are not possible values for that selection the object will not be visible

Hope it helèps

Re: Hide Filters if they contain null values

Fri, 01 Mar 2013 12:27:11 GMT

Hi Ive set the condition as you suggested but the filter is still visible (see attached screen shot). Im testing it with the field Filter 7 as I know this field is has not data in it.

Any suggestions?

Thanks

Fiorano

Re: Hide Filters if they contain null values

alexandros17 — Fri, 01 Mar 2013 12:42:07 GMT

HI,

the question now is:

when you make a selection what do you see in the fields that you do not want to be visible?

If getpossiblecount doesnt work this means that any selecttons is possible ... may you check this?

Let me know

Re: Hide Filters if they contain null values

alexandros17 — Fri, 01 Mar 2013 12:48:03 GMT

I give you an example that works (select 1965)

Re: Hide Filters if they contain null values

Fri, 01 Mar 2013 16:03:42 GMT

This is what I need to to - Thanks!

There must be something wrong with my field. Even though it appears to be empty there must be some 'white space' value which making it stay visible.

Thanks again!

Fiorano