Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendrankr
Contributor III
Contributor III

YOY Growth in Drill-Down bar chart

Hi Team,

I am trying to show a bar chart with drill down option and the measure would be YOY growth.

I have  State, District and City as 3 dimensions and volume are measure.  I have used the below expression to compute the YOY growth.

Sum({1<Year={"2020"}>}[Sellout Qty])/Sum({1<Year={"2019"}>}[Sellout Qty])-1

The issue is when is use a simple bar chart ie., 3 bar charts individually for State, District and City, the above expression works fine.

However when i try to put all the 3 dimensions in the same bar chart using drill down in master dimension, the drill down is not functioning properly. When i click on a state, all districts in the country gets displayed irrespective of the state selected. Pl help.

 

Labels (1)
0 Replies