topic Pivot table (aggregation for the multiple dimension) in QlikView

Pivot table (aggregation for the multiple dimension)

Mon, 01 Jul 2013 13:10:52 GMT

Hello,

How I can achieve the following?

Thanks

kaushiknsolanki — Mon, 01 Jul 2013 13:20:05 GMT

Try this expression.

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

Regards,

Kaushik Solanki

Mon, 01 Jul 2013 13:29:50 GMT

I found it

sum(aggr(nodistinct

sum(x/y)

,vari_code))

Mon, 01 Jul 2013 13:33:24 GMT

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 — Mon, 01 Jul 2013 13:37:35 GMT

Try this....

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