topic Re: Count units between weeks in QlikView

Count units between weeks

Anonymous — Thu, 23 Jul 2015 12:07:51 GMT

Hi all,

I'm struggling.

What I'm trying to do is count how many units were sold between two weeks ago and 24 weeks ago.

My expression is below,

sum({<UNIT.SOLD_WEEK= {"<=$(=$(Week(today())-2)>=$(=$(Week(today())-24)"} UNIT.TOTALSOLD)

Could anyone point out where I'm going wrong?

Thanks

Gareth

Kushal_Chawda — Thu, 23 Jul 2015 12:14:30 GMT

try,

sum({<UNIT.SOLD_WEEK= {"<=$(=Week(today())-2)>=$(=Week(today())-24)"} >}UNIT.TOTALSOLD)

sunny_talwar — Thu, 23 Jul 2015 12:27:25 GMT

Can also try this:

Sum({<UNIT.SOLD_WEEK= {"$(='<=' & (Week(Today())-2) & '>=' & (Week(Today())-24))"}>} UNIT.TOTALSOLD)

Thu, 23 Jul 2015 12:27:35 GMT

Hi,

you missed out the set modifier and thats why the error.

Try like this:

sum({<UNIT.SOLD_WEEK= {">=$(=Week(today())-24)<=$(=Week(today())-2)"} >}UNIT.TOTALSOLD)

sgrice — Thu, 23 Jul 2015 12:28:31 GMT

This will not work over year end.

You will need a Absolute week number to do this.

Anonymous — Thu, 23 Jul 2015 12:47:26 GMT

Thanks everyone you've all been a great help!