How to get totals in drill down for labels

[Baavik]

Hi everyone,

 I am struggling in how to get totals for the labels in drill-down in QlikSense.

For ex : I have taken different regions and when I do drill down, I need to get the count of sub-regions like HBAP(2), HBEU(3), HNAH(3),...displayed  in the chart.

Kindly suggest !! TIA !!

[HeshamKhja1]

hmm, it might be possible to append the count of subregions with region name through some dimension manipulation. But before we go into that, did you try adding two dimensions in the bar chart?

Example:

[Baavik]

@HeshamKhja1 - Yup I have added two dimensions in the chart.

Also in my app there are around 25-30 sub-regions in a single Region. So showing all those in the same bar does not work as shown above. 

Thanks !!

[HeshamKhja1 · Accepted solution]

I see!

Maybe try this dimension in the bar chart:

=Region & ' (' & Aggr(count([Sub Region]), Region) & ')'

[MatheusC]

Hi, @Baavik 

Look this
sum(total<sub-regions>sales)

Inside the <>, it is who you want to show the totals for.

I believe this meets

[Baavik]

@HeshamKhja1  It works !!

Thanks alot !!