Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-07-01 09:10 AM

Pivot table (aggregation for the multiple dimension)

Hello,

How I can achieve the following?

table.png

Thanks

Labels (1)
Labels
calc.qvw
1,540 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2013-07-01 09:29 AM
Author

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

View solution in original post

1,342 Views
0 Likes
4 Replies
kaushiknsolanki
MVP
MVP
‎2013-07-01 09:20 AM

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!
1,342 Views
Not applicable
‎2013-07-01 09:29 AM
Author

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

1,343 Views
0 Likes
Not applicable
‎2013-07-01 09:33 AM
Author

In response to

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.

1,342 Views
0 Likes
jolivares
Specialist
Specialist
‎2013-07-01 09:37 AM

In response to kaushiknsolanki

Try this....

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

1,342 Views
0 Likes