Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Specialist
Specialist

Is it possible to load empty data in to sheet?

what does empty here means?

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

Highlighted
Partner
Partner

Is it possible to load empty data in to sheet?

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

Highlighted
Employee
Employee

SV:Re: Is it possible to load empty data in to sheet?

Highlighted
Employee
Employee

SV:Re: Is it possible to load empty data in to sheet?

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

Highlighted
Partner
Partner

SV:Re: Is it possible to load empty data in to sheet?

Thanks a lot this help me