Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

Is it possible to load empty data in to sheet?

Hi,

- I generated the reports based on the loaded data from the edit script.

- Now, the reports are generating what i need exactly. In the report i have different straight table, bar charts along with the listbox and input box.

- When i select the values in the listbox reports are generating based on the selection only. But, when i click CLEAR or unselection process is done the reports what i generated is not empty.

But, when i click CLEAR or unselection process is done the reports what i generated is to be empty.

How can i rectify this problem? Is there any solution for this?

If possible plz help me..........

5 Replies
AbhijitBansode
Specialist
Specialist

what does empty here means?

when Clear is click, logicallly all selection should roll back to the default selections.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Empty means there should be no data in the all charts.

ToniKautto
Employee
Employee

ToniKautto
Employee
Employee

My recommendation is to not hide the data but instead hide the entire objects, to get an easier to understand design of your application. Hidden object will also be hidden in your reports.

Object Properties > Layout tab > Conditional show

Here you simply add an expression that return true when a object should be shown or false when it should be hidden.

Functions like GetPossibleCount() and GetSelectedCount() can be very efficient ways to identify conditional show based on field selections.

For example, show the object if more than zero items are selected in the FieldName;

=if( GetSelectedCount(FieldName)>0, True(), False() )

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Thanks a lot this help me