topic How to show values in chart only with in date range? in QlikView

How to show values in chart only with in date range?

Fri, 08 May 2015 13:26:38 GMT

Hi,

I have dimension and expression as below

Dimension: Region

Expression: count(Id)

now I need to show count(Id) only within week. so, the week should be from Last Friday to current Thursday.

for eg: count(id) should show values from 01/05/2015 to 07/05/2015. This should appear for further weeks also. so, if I run report next week it should be from 08/05/2015 to 14/05/2015 and so on.

Please can anyone suggest me how to do this.

EDIT : I have Date field named as EnterDate

Thanks.

Re: How to show values in chart only with in date range?

Fri, 08 May 2015 13:52:00 GMT

please can anyone suggest me this

Re: How to show values in chart only with in date range?

pokassov — Fri, 08 May 2015 13:57:13 GMT

Hello!

count({$<EnterDate={'>=$(=date(WeekStart(Today(),0,-3)))<=$(=date(WeekEnd(Today(),0,-3)))'}>}Id)

Re: How to show values in chart only with in date range?

jonathandienst — Fri, 08 May 2015 14:16:38 GMT

Assuming you mean a rolling 7 days - something like:

Count({<EnterDate = {">=$(=Today()-7)<$(=Today())"}> Id)

Re: How to show values in chart only with in date range?

Fri, 08 May 2015 14:31:32 GMT

Thanks. if I want to use expression as dimension how to do this?

so, I need dimension as Week should show week number as from Last Friday to current Thursday

Re: How to show values in chart only with in date range?

pokassov — Fri, 08 May 2015 15:49:38 GMT

The best solution is creating calendar with EnterData and Week name with your constraint...

However you can do something like this:

=aggr(WeekName(WeekStart(EnterDate,0,-3)),EnterDate)