Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
My requirement is, want to convert this expression to qlikview expression.
Here we are taking [Start Date] and [End Date] from the calendar variable, mean to say dynamically and finally i want total count of all the counts.
Case
WHEN [Receive Date] BETWEEN [Start Date] AND [End Date]
AND [Policy Symbol] IN ('MAC', 'PAC', 'GLP', 'CPP')
THEN 1
ELSE 0
END
Try this.
if(wildmatch([Policy Symbol],'MAC', 'PAC', 'GLP', 'CPP') and [Receive Date] >= [Start Date] and [Receive Date] <=[End Date],1,0)
Regards,
Kaushik Solanki