Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Pivot table (aggregation for the multiple dimension)

Hello,

How I can achieve the following?

table.png

Thanks

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Pivot table (aggregation for the multiple dimension)

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

4 Replies

Re: Pivot table (aggregation for the multiple dimension)

Try this expression.

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

Regards,

Kaushik Solanki

Highlighted
Not applicable

Re: Pivot table (aggregation for the multiple dimension)

I found it

sum(aggr(nodistinct

 

                              sum(x/y)

 

,vari_code))

Not applicable

Re: Pivot table (aggregation for the multiple dimension)

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
Valued Contributor

Re: Pivot table (aggregation for the multiple dimension)

Try this....

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