8 Replies Latest reply: Nov 17, 2014 8:23 AM by Christian Wylezol RSS

    if or if statement in qlikview

    Christian Wylezol


      Hello everybody,

       

      i have a (for me) difficult issue.

      I have two dimension fields (postrulecode and assetstatus) with infos and want to create a third dimension (constructionstatus) which is dependent on the both before.

       

      =IF(postrulecode='0450','under Construction',

      OR
      IF(assetstatus='INTRAY','under Construction',

       

       

       

      //[ELSE]

       

      'ASSET'))

       

      What is wrong in this formular?

       

      Very much thanks in advance