Aggr roll up issue

[preminqlik]

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]

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

[Gysbert_Wassenaar]

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

[swuehl · Accepted solution]

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]

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]

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