topic Re: 90 Days Rolling in QlikView

90 Days Rolling

sat_tok52 — Fri, 20 Nov 2015 06:11:38 GMT

Hi Guru's

I want show 90 days rolling on bar chart,i have a date column and i written expression like below.

count({<Date={'>=$(=Date-90)<=$(=Date(Today()))'}>} Id)

Any help thanks in advance.

Thnaks,

Sateesh

tamilarasu — Fri, 20 Nov 2015 06:17:07 GMT

Hi,

Try,

count({<Date={">=$(=Date(Today()-90))<=$(=Date(Today()))"}>} Id)

Make sure your date field format should match with expression. Else you need adapt like

count({<Date={">=$(=Date(Today()-90,'DD/MM/YYYY'))<=$(=Date(Today(),'DD/MM/YYYY'))"}>} Id)

Change the highlighted format to your Date field format.

Let me know.

jagan — Fri, 20 Nov 2015 06:47:19 GMT

Hi,

I think date format is the issue

Count({<Date={'>=$(=Date(Date-90))<=$(=Date(Today()))'}>} Id)

Check this link

harithadogiparthi505 — Thu, 22 Sep 2022 11:09:34 GMT

Hello,

I have encouraged an error when placed in a pivot table one week is showing data and when 2 weeks get selected second week data is missing. Any help?