Date Count

Thu, 28 Mar 2013 07:24:38 GMT

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

Re: Date Count

kaushiknsolanki — Thu, 28 Mar 2013 07:27:05 GMT

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