topic Re: Expression from data in Qlik Learning Discussions

Expression from data

Mon, 01 Sep 2014 16:59:37 GMT

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.

Re: Expression from data

maxgro — Mon, 01 Sep 2014 17:21:40 GMT

maybe with an expression like

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

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

sum(Expresion)))

Re: Expression from data

Agis-Kalogiannis — Mon, 01 Sep 2014 19:10:45 GMT

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

Re: Expression from data

Tue, 02 Sep 2014 10:05:39 GMT

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/

Re: Expression from data

Tue, 02 Sep 2014 10:08:18 GMT

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.