topic Re: How to get totals in drill down for labels in App Development

How to get totals in drill down for labels

Baavik — Fri, 15 Nov 2024 21:17:29 GMT

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 !!

Re: How to get totals in drill down for labels

HeshamKhja1 — Mon, 30 Oct 2023 10:46:54 GMT

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:

Re: How to get totals in drill down for labels

Baavik — Mon, 30 Oct 2023 11:04:44 GMT

@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 !!

Re: How to get totals in drill down for labels

HeshamKhja1 — Mon, 30 Oct 2023 11:07:57 GMT

I see!

Maybe try this dimension in the bar chart:

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

Re: How to get totals in drill down for labels

MatheusC — Mon, 30 Oct 2023 12:49:18 GMT

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

Re: How to get totals in drill down for labels

Baavik — Tue, 31 Oct 2023 05:39:39 GMT

@HeshamKhja1 It works !!

Thanks alot !!