Date Count

[#1]

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

[kaushiknsolanki]

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