Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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
Not applicable

Re: Expression from data

maybe with an expression like

=

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

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

sum(Expresion)))

alk
Not applicable

Re: Expression from data

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

Not applicable

Re: Expression from data

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

Re: Expression from data

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.

Community Browser