Discussion Board for collaboration on QlikView Scripting.
I have the below statement that shows without error, but is only giving 1 scenario instead of both.
=if(Closed_Date =' ' AND [Sbu_Desc]='UNKNOWN'
,'Complaint In Progress',
Go to Solution.
Sorry my mistake.
If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc, 'UNKNOWN'),'Complaint in Progress','Known')
You can try this.
If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc = 'UNKNOWN'),'Complaint in Progress','Known')
Thanks but its giving me an error in expression and no result
Make sure that you have put correct name of the fields.
The expression it self will show where is the mistake by red line.
Its showing a red line at the bracket and comma between UNKNOWN and Complaint in Progress.
'UNKNOWN'),'Complaint in Progress
Thank you sooooo much :-)