1 Reply Latest reply: May 17, 2013 9:23 AM by Vishwaranjan Kumar RSS

    Condition for expression

      Hi dev people, I´m new to QlikView and I have some problems with expressions.

       

      What I am trying is to create a pivot table with 2 dimensions and 2 expressions.I want to show only one expression depending on a flag file(Flag_ist), so I am using the conditional feature for expressions.

       

      1° Problem,

       

      My flag field is correct, but if I can not use it properly in the Condition for the expression because it returns -1 when the value is true (When it is false, returns 0, so OK). I have checked also my flag field with an if statement and it stills return -1.

       

       

       

      2° Problem

       

      I change the condition expression.

       

       
       //This is not working... I get always sum(sales)
       Condition 
           if(Flag_ist=0,0,1) 
       Expression
            sum(sales)
       
       //This works
       
       Condition
            Anything
       Expression   
           if(Flag_ist=0,0,sum(Sales)) 
      
      
      

       

      The values I get from the if are correct, sometimes 0 and sometimes 1. The problem now is that the final expression is always used. I can not hide the expression if I use the condition field.

       

       

      I can use the second way, but if qlikview has a special field for the condition I would like to use it.

       

       

       

      Thank you very much,,

      Angel