Default selection

[#1]

Hi all,

I have attached a screenshot of the sheet.

Where i have used the image and text objects and Filter pane.

The issue is the default data is displaying without any selection in filter pane.

I need to exclude the default selection and the data should display only when the selection is made in filter pane.

Help on this.

Thanks,

Pramod

[ToniKautto]

Why is your data not in charts or table objects?

[#3]

Hi Toni Kautto,

I have used the "Text and image object" to display the data.

You can see in filter pane i have not selected any data. but also it is displaying the data.

i need that should be blank till i select value in filter pane.

Thanks,

Pramod

[rbecher]

Hi Pramod,

you can use Only( ) function:

=Only(' .. your text with data .. ')

- Ralf

[#5]

Hi Ralf Becher,

It's work fine for some data. But for set analysis it's not working.

Concat(DISTINCT subjectid, '-', subject_access_track_id)

count({<subject_status = {"Passed","Completed"}>}DISTINCT subjectid)

Would you please help how to use only()  to the above expressions.

Thanks,

Pramod

[rbecher]

Could you upload a sample app?

[#7]

Hi Ralf Becher,

Please find the attachment

Thanks,

Pramod

[madhumitha]

Hi Pramod,

Try using Clear all thro Triggeres is Sheet or Document properties.

[rbecher]

Where is it?

[#10]

sorry,

will you please help me how to produce sample app?

Thanks,

Pramod