How to display only if there is data (Filter Pane) ?

[Masterclass77]

Hi,

I would like in my sheet to display in a filter pane the data only if it shows me the graph.

For example, here I have no data for these dates, so I would like these dates not to be present in the filter pane:

For these dates I have a lot of data so they remain visible :

Thank's for your future help 🙂 

And sorry for my english, i'm french ^^

[joaopaulo_delco]

Hi @Masterclass77 !

             You should resolve this situation in the script. Can you share your script for take a look?

[rbartley]

Hi,

You need use the P() modifier, which returns only the possible values.  Just replace "Date Field" in the expression below with the name of your date field.  

=aggr(only({1< [Date Field]= p( [Date Field])>} [Date Field]),[Date Field])

[Masterclass77]

Yes,

Expression of Filter Pane :

The Graph : 

And Data model in QS :

[Masterclass77]

i don't have a date field but a time table in my BDD with : ID_TIME, YEAR, MONTH, DAY

This is my expression in my filter pane :

[rbartley]

It would make sense to include a date field in your load script so that you don't have to repeat this expression every time you want to use the date.  It will also be simpler to modify the filter pane.

If you export and post the qvf file, it will make it easier for people to help you.  If the data is confidential, find a way of replacing the confidential data and then post it.

[joaopaulo_delco · Accepted solution]

Hi @Masterclass77 !

            Try to change moving the TEMPS table to the end of the script and add this "Exists" function like below:

[Masterclass77]

It's good thank's a lot !!  😊