Total <x,y> and calculated dimensions

[Sa_Rah]

Hi

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?

[rwunderlich · Accepted solution]

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

[Sa_Rah]

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