topic Total <x,y> and calculated dimensions in App Development

Total and calculated dimensions

Sa_Rah — Mon, 30 Oct 2023 15:58:58 GMT

I'm back with another question

I'm using these formulae to choose Dimension 1 and Dimension 2 (thanks to @vincent_ardiet_ for this ) :

Dimension 1 : $(=pick($(vDimension1), 'Division', 'Specialty', 'StGr'))

Dimension 2: $(=pick($(vDimension2), 'Division', 'Specialty', 'StGr'))

My problem now is that I want to calculate the following formula which will change depending on what the 2 dimensions are selected to be:

count ( total <Dimension 1,Dimension 2> distinct [EmpNo])

I know I can't use calculations within the TOTAL <> brackets, but I'm unsure what to do instead - I need to use this as the denominator in a % formula

Could someone help?

Re: Total and calculated dimensions

rwunderlich — Mon, 30 Oct 2023 17:16:29 GMT

You can write the expression as:

count ( total <Division, Specialty, StGr> distinct [EmpNo])

Meaning list all potential dimensions in <>. Qlik will simply ignore Dimensions that are not part of the chart.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Total and calculated dimensions

Sa_Rah — Mon, 30 Oct 2023 17:35:19 GMT

Thank you! That's worked perfectly (again apologies for the automatic marking as a solution, but this time it didn't matter).