Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression from data

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.

4 Replies
maxgro
MVP
MVP

maybe with an expression like

=

if(Expresion = 'B+C', sum(B)+sum(C),

if(Expresion = 'C+A', sum(C)+sum(A),

sum(Expresion)))

Agis-Kalogiannis
Employee
Employee

Could you please give us some more information about your business case Paulus?

Not applicable
Author

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/

Not applicable
Author

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.