Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was working with Qlikview and have stuck in this case.
I have this sample data
LOAD * INLINE [
A,B,C,Expresion
10,20,30,20
20,30,40,B+C
30,40,50,C+A
40,50,60,40
];
And I need to make a chart which the result is
A Expresion
10 20
20 70
30 90
40 40
Anyone have any idea for this case? really need help here.
Thank you.
maybe with an expression like
=
if(Expresion = 'B+C', sum(B)+sum(C),
if(Expresion = 'C+A', sum(C)+sum(A),
sum(Expresion)))
Could you please give us some more information about your business case Paulus?
Hi Massimo Grossi,
Thanks for your reply.
Your solution is great, and it's working well. But, What if the expresion field is added more data? Do you have any solution so I no need to add the expresion manually?
Thank you/
Hi Agis Kalogiannis,
Thank you for your reply.
My user is want a flexible expression for his dimension, because sometime for one dimension it's just a fix value, but for another dimension is a formula, and the formula can be different between dimension.
I hope it can help.
Thank you.