topic Re: How to display only if there is data (Filter Pane) ? in App Development

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

Masterclass77 — Fri, 12 Mar 2021 11:11:48 GMT

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 ^^

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

joaopaulo_delco — Fri, 12 Mar 2021 12:04:09 GMT

Hi @Masterclass77 !

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

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

rbartley — Fri, 12 Mar 2021 12:09:59 GMT

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])

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

Masterclass77 — Fri, 12 Mar 2021 12:27:49 GMT

Yes,

Expression of Filter Pane :

The Graph :

And Data model in QS :

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

Masterclass77 — Fri, 12 Mar 2021 12:37:09 GMT

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 :

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

rbartley — Fri, 12 Mar 2021 12:42:42 GMT

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.

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

joaopaulo_delco — Fri, 12 Mar 2021 13:51:11 GMT

Hi @Masterclass77 !

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

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

Masterclass77 — Fri, 12 Mar 2021 14:08:05 GMT

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