Hide Filters if they contain null values

[#1]

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

[nirav_bhimani]

Hi,

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

where len("ColumnName")<> 0;

Regards,

Nirav Bhimani

[alexandros17]

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

[#4]

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

[alexandros17]

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

[alexandros17 · Accepted solution]

I give you an example that works (select 1965)

[#7]

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