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

Help with pivot table expression

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.

5 Replies
rajni_batra
Specialist
Specialist

i think u can use column function

eg.

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

hope this help

Not applicable
Author

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.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein