Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i made formule in pivot & chart like this avg(if,than.if(than, if(than,else),else))...
the resolt in the line is O.K. but in sum the resolt is not good
exm:
resolt line 1 - 4
resolt line 2 - 17
resolt line 3 - 7
in the sum line it's show 4 !!
what can be the problem ?
thanks'
yarin
hi
the problem is that
qlikview evaluates the formula for the total field also and apparently it answers the first condition
you'll need to use this as your expression
sum(aggr( avg(if,than.if(than, if(than,else),else)),YourDimensions))
Hi
Can you post your expression for Sum
Thanks
Hi,
Can you post screen shot of your chart???
Try aggr()
try like avg(aggr(YourExpression,dim))
Regads
Hi ,
I hope ,
In your expression ,
(if,than.if(than, if(than,else) Its fine but you have to aggr for the final else with your dimensions,
Can you post your sample if possible,
-Hirish
Hi,
avg(aggr(avg(if,than.if(than, if(than,else),else)), your dimention fields1,your dimention field2....))