Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
i think u can use column function
eg.
if column(1)=red ,1,0 in calculated dimension
hope this help
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.
If "color" is your dimension then your own expression above should be fine. What's the problem with If(color='red',1,0) ?
Hi
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
Unless of course color is the name of a calculated dimension...