Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
It should be calculated in front end it self...no scripting please
Use this instead to ignore selections in the ITEM field: sum({<ITEM=>} total QTY)
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.
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
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