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.
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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein