topic Re: Rolling up to Region in QlikView

Rolling up to Region

amijit_hazarika — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Rolling up to Region

sunny_talwar — Tue, 22 May 2018 14:59:46 GMT

May be use a calculated dimension

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

Re: Rolling up to Region

amijit_hazarika — Tue, 22 May 2018 15:03:20 GMT

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.

Re: Rolling up to Region

sunny_talwar — Tue, 22 May 2018 15:19:58 GMT

I am almost certain that you can.

Re: Rolling up to Region

shansundar — Tue, 22 May 2018 15:27:49 GMT

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