Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
WHEN [Receive Date] BETWEEN [Start Date] AND [End Date]
AND [Policy Symbol] IN ('MAC', 'PAC', 'GLP', 'CPP')
if(wildmatch([Policy Symbol],'MAC', 'PAC', 'GLP', 'CPP') and [Receive Date] >= [Start Date] and [Receive Date] <=[End Date],1,0)