topic Re: 100% Stacked Bar Chart and drill down in QlikView

100% Stacked Bar Chart and drill down

Fri, 18 Nov 2011 11:45:21 GMT

Hi All,

I have a bar chart which I have set up as a 100% stack with two dimensions:

- Org_Level_1

- Input_Type

...using the following calculation I can show the % of Employees (this all works fine):

=Count([Employee_Number])/Count(total<[Org_Level_1]> Employee_Number )

However I actually want to use a drill down group, but I'm unsure how to use the group within the expresson. The group consists of 5 fields within the organisation hierarchy i.e. Org_Level_1, Org_Level_2 etc; and the above calculation works obviously with the first level, but does not with the second.

Basically, how do I amend the calculation so that it flexes depending on the org level...

Your help is much appreciated...

Andrew

100% Stacked Bar Chart and drill down

Fri, 18 Nov 2011 12:26:21 GMT

Figured it out, and just in case anyone else wanted to know, using the same expression as above I just included all the org levels that appear in the drill down group i.e:

=Count([Employee_Number])/Count(Total<[Org_Level_1],[Org_Level_2],[Org_Level_3],[Org_Level_4],[Org_Level_5]> Employee_Number)

Andrew

Re: 100% Stacked Bar Chart and drill down

Paulexter — Thu, 23 Apr 2020 21:45:45 GMT

Thank you for this, I was trying all sorts of things with variables and could not get it to work. Who knew it was so simple!

Re: 100% Stacked Bar Chart and drill down

TgrPep — Fri, 20 Nov 2020 13:30:18 GMT

This was a huge help. Thank you for posting this