Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Drill down issue

Dear all,

I have bar char where I using three dimension as drill down.

Dime1

Dim2

Dim3

Issue :

In my data model I have there are few Null records in Dim2,

I have given specific name to that value named as Null_Dim2 ( If( Isnull(Dim2),'Null_Dim2',Dim2) as Dim2

now, I am using the Dim1 filed as reduction filed using section access and m applying section access to few data in Dim1, now after applying this what happens is

M directly drilled down to Dim3, it is not showing me Dim1 in the chart at all.

Please advise.

Regards,

Mahamed

2 Replies
Anil_Babu_Samineni

Can you please post sample qvw?

- Anil

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Mahamed_Qlik
Specialist
Specialist
Author

Hi Anil,

Please chck the attachment.

User name : demo2

password : 123

Regards,

Mahamed