Rolling up to Region

[amijit_hazarika]

Hello All,

I am working on the visuals of my QS app.

There is a stacked bar chart. There are 2 Dimensions - Region(East, West and North) and Status(In progress, Complete)

                                                                1 Measure - Count(Status) / Count(Total(Status))

Now there is a requirement where I am getting stuck.

User wants to drill down. Once you Choose any region it should go down to the states/province in that region. I can only use this 2 dimensions i.e. Region and Status.

Ex -  User chooses East, the graph should show a bar for East and new bars in that bar chart should pop up showing status for the states/provinces(Ontario, Saskatchewan)

Suggestions would be highly appreciated. stalwar1‌

Thanks

[sunny_talwar]

May be use a calculated dimension

=If(GetSelectedCount(Region) = 0, Region, State/Provinces)

[amijit_hazarika]

Thanks for your prompt response Sunny. I am not sure if we can do a calculated dimension in QSense. I will try using the one you suggested.

[sunny_talwar]

I am almost certain that you can.

[shansundar]

In Qliksense you can create a drill down dimension also (Type of the dim should be Drill down) and you can select the dimensions in that particular order you want to drill into.

Thanks,

Shan S