Retain filter pane selection if values not found

[#1]

Hi all,

reddys310‌

I am using two filter pane and dateRangePicker to filter the data.

Two filter panes are Client Name and Batch Name,

when i select the client name, batch name and after that date, if no value found for that client and batch then those selection is clearing and displaying the value of other clients belongs to that date. Instead i need to show zero for the selected client and batch.

Regards,

Pramod

[reddy-s]

Hi Pramod,

That's the default behavior of Qlik. As you have selected values which donot have any associations, the filters will be automatically dropped. As a work around, if you would like to show Zero's when these values are selected, you will have to append an extra row to the data set which says that the values are zero's for these values.

Thanks,

Sangram.

[#3]

it's removing my selection when their is no value for that selection. i need to retain that selection and as to display the zero values.

How to append an extra row to the data set which says that the values are zero's for these values?

[reddy-s]

Hi Pramod,

Just concatenate the remaining data using 0 in the measures.

For example:

Concatenate(Sales)

[No Sales Departments]:

Load * inline [

Department, Sales

X,0

Y,0

];

Now when you select Department 'X' you should be able to see 0 shown.

If you would like to find the departments with no sales use the where not exists() function.

Thanks,

Sangram.