2 Replies Latest reply: Feb 21, 2018 8:56 AM by Whiteside Kleinbreuer RSS

    How to use IF clause if lower level data set consist of multiple levels

    Whiteside Kleinbreuer

      Dear Qlik Community,

       

      I am facing an issue with an If clause.

       

      You see I am looking at 1 Shipment. 1 Shipment could have n status or text.

      The Formular in the Field "Exonerated Text/Status" is as followed:

       

      If (

          [Textcode key] =('T06') or [Textcode key] =('T08') or [Textcode key] =('T14') ,'Exonerated (textcode)'   

              ,If(

                  [Status code]=('U10') or [Status code]=('F02') or [Status code]=('F06') or [Status code]=('F09') or [Status code]=('S36') or [Status code]=('S94'),'Exonerated (Status Code)'

                      ,'Evaluated'))

       

      Now if i delete the dimension of the "Status Code"

      This is the what happens.

       

      Actualy I expect here the value "Exonerated (Status Code).

       

      Can anyone help me with the correct syntax?

       

      kind regards

      whiteside