6 Replies Latest reply: Jun 12, 2013 8:51 AM by Romina Villa RSS

    If nested three conditions

    Romina Villa

      Hi,

       

      I need create a dimension based on three conditions, I mean:

       

      if(isnull(a) and isnull(b) and (not isnull(c), 'Z',

      if((not isnull(a) and isnull(b) and isnull(c), 'Y')) as Dimension

       

      This for seven cases. Always the same three fields in the conditions, always if is null or not null.

       

      That code doesn't work in the script in Qlikview, neither:

       

      if(isnull(a),

           if(isnull(b),

                if((not isnull(c)),'Z',

           )

       

      How I do that dimension in Qlikview?

       

      Thanks. Regards.