topic Re: In expression check condition Max date equal to date in QlikView

In expression check condition Max date equal to date

sangeethag — Tue, 16 Feb 2016 11:52:34 GMT

Hi,

I have report date and calculated date in variable.

In my expression have to check condition like

if(Max(ReportDate)=Datevariable, Exp1, Exp1)

Is there any solution for this requirement?

ecolomer — Tue, 16 Feb 2016 18:57:12 GMT

Can you explain your question more, please?

sunny_talwar — Tue, 16 Feb 2016 18:58:01 GMT

I think you will have to provide more information before we can help you. Do you have a sample you can provide?

sangeethag — Wed, 17 Feb 2016 06:10:02 GMT

Thank you for replies.

I have found the solution for this.

We can use like below

if(Max(Date([Report_Date],'DD/MM/YYYY'))=Date('$(vQ1End)','DD/MM/YYYY'),Exp1,Exp2)