Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Date Count

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

1 Reply

Re: Date Count

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

Community Browser