If statement is not working in Table in Qlik sense

[mhmmd_srf]

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

[shraddha_g]

Try

if(

wildmatch(prb_flag,'Closed') and wildmatch(prb_taskslatable_stage,'completed')  and wildmatch(prb_taskslatable_stage ,'*response*')

,prb_taskslatable_end_time,000

)

[mhmmd_srf]

Hi Shraddha,

No Luck with this.

Any other thought?

Thanks,
Sarif

[shraddha_g]

can share a app with sample data?

[SergeyMak]

Hi,

Please try

if(

prb_flag='Closed' and wildmatch(prb_taskslatable_stage,'completed',*response*'),

prb_taskslatable_end_time,

000

)

I can also advise to move this statement to the load script and in this case you will no need to use calculated value, but just show a new field

If it doesn't work, please share your app.

Regards,

Sergey

[mhmmd_srf]

Sorry Shraddha..it is working.. I have mistakenly used wrong field name.

[shraddha_g]

great