topic Re: Aggr roll up issue in QlikView

Aggr roll up issue

preminqlik — Sat, 28 Dec 2013 14:39:04 GMT

Hi guys ,

Please find below qvw,

Here i calculated the roll up sum for dimension Rate area in expression named "Rate Area total". it is working perfectly fine ,

but when am clicking on Item , the value is disturbing

for eg : without selecting item1 the value is 610 (Correct)

after selecting Item1 the value is 200 (wrong it should be 610 only)

thanks in advance..

preminqlik — Sat, 28 Dec 2013 14:45:42 GMT

It should be calculated in front end it self...no scripting please

Gysbert_Wassenaar — Sat, 28 Dec 2013 14:46:53 GMT

Use this instead to ignore selections in the ITEM field: sum({<ITEM=>} total QTY)

swuehl — Sat, 28 Dec 2013 14:57:47 GMT

I am not 100% sure what you are trying to achieve, I assume you want to calculate a total within the context of your table chart, maybe like

=sum(QTY) / sum({<ITEM=>} total<[SHIPMENT NUMBER]> QTY)

to calculate the percentage.

Check also attached.

preminqlik — Sat, 28 Dec 2013 15:26:33 GMT

hey gysbert thanks ...your expression is working in Qlikview 11.2 perfect

actually my expression seems to be like this

sum(aggr(nodistinct sum({<Item=>}(QTY*Volume)),ShipementNo))

here volume is coming from another table

not working in qlikview 9.0

thanks

preminqlik — Sat, 28 Dec 2013 15:27:38 GMT

hey thanks perfect....

your expression i.e

if(sum(QTY),sum({<ITEM=>} total<[SHIPMENT NUMBER]> QTY))

also works in qlikview 9.0 too

many thanks

Prem