topic Date Restriction is not Working Properly in QlikView

Date Restriction is not Working Properly

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date Restriction is not Working Properly

vishsaggi — Wed, 20 Sep 2017 13:04:06 GMT

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)

Re: Date Restriction is not Working Properly

mostwanted123 — Wed, 20 Sep 2017 13:08:16 GMT

Try this,

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

Regards,

Pratik

Re: Date Restriction is not Working Properly

Clever_Anjos — Wed, 20 Sep 2017 13:08:49 GMT

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

Re: Date Restriction is not Working Properly

mhmmd_srf — Wed, 20 Sep 2017 13:13:53 GMT

This is not working.

Re: Date Restriction is not Working Properly

sunny_talwar — Wed, 20 Sep 2017 13:21:51 GMT

Try this

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

Re: Date Restriction is not Working Properly

vishsaggi — Wed, 20 Sep 2017 13:35:43 GMT

Can you share your sample app to look into?

Re: Date Restriction is not Working Properly

Anonymous — Wed, 20 Sep 2017 17:13:27 GMT

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