Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Retain filter pane selection if values not found

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

Tags (1)
3 Replies
reddys310
Honored Contributor II

Re: Retain filter pane selection if values not found

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.

Not applicable

Re: Retain filter pane selection if values not found

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?

reddys310
Honored Contributor II

Re: Retain filter pane selection if values not found

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.

Community Browser