Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
if(
wildmatch(prb_flag,'Closed') and wildmatch(prb_taskslatable_stage,'completed') and wildmatch(prb_taskslatable_stage ,'*response*')
,prb_taskslatable_end_time,000
)
Hi Shraddha,
No Luck with this.
Any other thought?
Thanks,
Sarif
can share a app with sample data?
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
Sorry Shraddha..it is working.. I have mistakenly used wrong field name.
great