Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table (aggregation for the multiple dimension)

Hello,

How I can achieve the following?

table.png

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

View solution in original post

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this expression.

sum(total <vari_code>Aggr(sum(x)/sum(y),vari_code,no))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

Not applicable
Author

I prefer to simplify the expression. Try:

     Sum(TOTAL <vari_code> x/y)

And use 0 as the Null symbol to show 0 instead of null default symbol.

jolivares
Specialist
Specialist

Try this....

Aggr(NODISTINCT Sum(x/y),vari_code)