topic Re: Set Expression in QlikView

Set Expression

Sat, 10 Aug 2013 06:47:23 GMT

Hi Community,

I have one problem with set expression.

In my pivot table i have three expression with one dimension.

3rd expression is sum(expression1)/sum(expression2)

its gives me currect output at row lavel but at bottum i want total of expression3 but

it was not appear.

Thanks

nagaiank — Sat, 10 Aug 2013 07:01:45 GMT

Try using a straight table instead of pivot table.

Sat, 10 Aug 2013 07:08:16 GMT

i tried but striaght table is also not reflecting with output that i want.......

VishalWaghole — Sat, 10 Aug 2013 07:10:35 GMT

Try this

sum(aggr(sum(expression1)/sum(expression2),Dimenssion))

Thanks