topic Is it possible to load empty data in to sheet? in QlikView

Is it possible to load empty data in to sheet?

jagannalla — Thu, 28 Apr 2011 06:13:21 GMT

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

Is it possible to load empty data in to sheet?

AbhijitBansode — Thu, 28 Apr 2011 06:28:11 GMT

what does empty here means?

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

Is it possible to load empty data in to sheet?

jagannalla — Thu, 28 Apr 2011 06:44:21 GMT

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

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

ToniKautto — Thu, 28 Apr 2011 08:00:05 GMT

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

ToniKautto — Thu, 28 Apr 2011 08:06:17 GMT

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

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

jagannalla — Thu, 28 Apr 2011 09:34:44 GMT

Thanks a lot this help me