Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Block drill down or Isolate drill down?

I three graphs and all data comes from the same table, I would like to use when you drill down from a chart the other are not affected.

Example:
Sem título.png

When I select the first graph commission other graphics can not be changed.


How do I do that?

3 Replies
Not applicable
Author

you can add {1} in the measure

e.g. SUM({1} Revenue)

but you won't be able to filter down the charts you use it on. (you could drill down the first graph and the others wouldn't change)

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Use the set analysis to do this.

All you have to do is, deselect the field in other chart.

For example, for 1st chart write expression as

Sum({<Product = , Customer = >}Sales)

For 2nd

Sum({<Account= , Customer = >}Sales)


For 3rd


Sum({<Product = , Acocunt= >}Sales)



Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author