Date Restriction is not Working Properly

[mhmmd_srf]

Hi All,

I have a requirement to show last 5 days data in Line Chart.

I have used the below expression:

=Sum({$<M_DATE={">=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 5)))","<=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 0)))"}>} ORD_LINE_CNT)

But it is not restricting. Showing all day's data.

Could you please help me on this.

Thanks ,

Sarif

[vishsaggi]

What is your date formats of M_DATE and your variable vDate?

may be try this?

=Sum({$<M_DATE={"$(= '>='& Date($(vDATE),'M/D/YYYY') - 5)  & '<=' & Date(Max($(vDATE)),'M/D/YYYY'))"} >} ORD_LINE_CNT)

[mostwanted123]

Try this,

Sum({<M_DATE={">=$(=max($(vDate)-5))<=$(=max($(vDate)))"}>}ORD_LINE_CNT)

Regards,

Pratik

[Clever_Anjos]

Put you expression into an expression of a straight table with no header

mouse over the expression so you can see how your expression is beeing evaluated

[mhmmd_srf]

This is not working.

[sunny_talwar]

Try this

=Sum({$<M_DATE={">=$(=Date(Max(M_DATE) - 5, 'M/D/YYYY'))<=$(=Date(Max(M_DATE), 'M/D/YYYY'))"}>} ORD_LINE_CNT)

[vishsaggi]

Can you share your sample app to look into?

[Anonymous]

Hi Mohammad,

I have deleted the other thread that was a duplicate of this one, and have restored this thread to an un-answered question.

In the future, if you accidentally post a question twice, you can delete one of them by following the steps listed here: Qlik Community Tip: How to Delete a Post

Best regards,

Qlik Community Team