Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ratio to third level subtotal

I have a pivot table where I calculate ratios of the values to the subtotals.

I was using the following expression to divide each cell by the first subtotal(second level):

count(distinct Person)/count(distinct total <[Dimension1]> Person)

Now I need to group it by 2 dimensions. I need to divide by the second subtotal(third level)

How can I adapt the expression to be used with 2 dimensions?

This way is not accepted:

count(distinct Person)/count(distinct total <[Dimension1]> <[Dimension2]> Person)

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can simply list the dimensions separated by comma's:

count(distinct Person)/count(distinct total <[Dimension1],[Dimension2]> Person)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

You can simply list the dimensions separated by comma's:

count(distinct Person)/count(distinct total <[Dimension1],[Dimension2]> Person)


talk is cheap, supply exceeds demand

View solution in original post