6 Replies Latest reply: Dec 7, 2016 6:58 AM by Shraddha Gajare RSS

    If statement is not working in Table in Qlik sense

    Mohammad Sarif

      Hi All,

       

      I have one Table in QlikSense. One field I want to make as below statement:

      if((prb_flag='Closed' and prb_taskslatable_stage='completed'  and prb_taskslatable_stage ='*response*'),prb_taskslatable_end_time,000)

       

      Unfortunately it is always showing 000 even if it matches criteria. If I remove prb_taskslatable_stage ='*response*', then it is working fine.

       

      Can anyone suggest how to implement that in Qlik Sense.

       

      Thanks,

      Sarif