topic Re: Help with pivot table expression in QlikView

Help with pivot table expression

Wed, 05 Sep 2012 08:53:29 GMT

In my report pivot table have two dimensions. Based on the value of the dimension I want to perform calculation through expression, suppose my first dimension is about color then i want to put condition in expression like that if (color = 'red', 1, 0).

Is it possible to achieve in QlikView, is there any way.

Re: Help with pivot table expression

rajni_batra — Wed, 05 Sep 2012 11:32:53 GMT

i think u can use column function

eg.

if column(1)=red ,1,0 in calculated dimension

hope this help

Re: Help with pivot table expression

Thu, 06 Sep 2012 05:42:17 GMT

Thanks Rajni for your comment.

I have already tried this option but unfortunately it didn't work, in Pivot table column(1) is treated as the first expression used in pivot table and not the dimension.

I want to play around the dimension.

Re: Help with pivot table expression

Jason_Michaelides — Thu, 06 Sep 2012 06:14:05 GMT

If "color" is your dimension then your own expression above should be fine. What's the problem with If(color='red',1,0) ?

Re: Help with pivot table expression

jonathandienst — Thu, 06 Sep 2012 06:24:45 GMT

Your if expression looks OK to me. I suggest that you post a little more detail about your chart object (dimensions and expressions) and what you are expecting from them, or better still, post your application or a sample tp illustrate the problem.

Regards

Jonathan

Re: Help with pivot table expression

jonathandienst — Thu, 06 Sep 2012 06:25:28 GMT

Unless of course color is the name of a calculated dimension...