Drill down in Qliksense

[Shubham_Deshmukh]

I have data like below where I want to show Not applicables only in drill downs.

id	Rule1	Rule2	status
1	A	x	Applicable
1	A	y	Not Applicable
1	A	z	Applicable

Master item : 1-Rule1 where status='Not applicable'  , 2- Rule2

Expression : count({<[status]={'Not Applicable'}>} distinct id)

Before drill down : 

When I click on yellow bar, then it should show only 1 bar of Not Applicable status (Rule- 'y'), but it shows all 3 charts with 1 count which is wrong.

Desired output : 

Is it issue with data format?

edit : Master item : 1-Rule1 where status='Not applicable'  , 2- Rule2

Regards,

Shubham

[anushree1]

Hi,

I do not see any condition written for showing not applicable status.

Could you please share the sample input and desired output for a better understanding here

[Shubham_Deshmukh]

Hi,

Sorry, forgot to mention the condition, pls check the edit.

Also I already tried same condition in both master drill down fields.

[Shubham_Deshmukh]

Hi @anushree1 ,

Sample input is already there and desired output I mentioned in the post.