topic Re: Last Quarter in QlikView

Last Quarter

Anonymous — Thu, 12 Nov 2015 09:44:07 GMT

Hi all,

I'm trying to count how many units were sold last quarter. For this quarter I can do the below and it gives the correct figures.

sum({<UNIT.SOLD_DATE = {">=$(=date(quarterstart(today()))) <=$(=date(quarterend(today())))"}, >} UNIT.TOTALSOLD)

In my head I should be able to do the following,

sum({<UNIT.SOLD_DATE = {">=$(=date(quarterstart(today())))-1 <=$(=date(quarterend(today())))-1"}, >} UNIT.TOTALSOLD)

But this doesn't work, has anyone got any ideas as it seems quite simple?

Thanks

Gareth

MayilVahanan — Thu, 12 Nov 2015 09:47:02 GMT

Try like this

sum({<UNIT.SOLD_DATE = {">=$(=date(quarterstart(today(),-1))) <=$(=date(quarterend(today(),-1)))"}, >} UNIT.TOTALSOLD)

tresB — Thu, 12 Nov 2015 09:48:58 GMT

Try like:

sum({<UNIT.SOLD_DATE = {">=$(=date(quarterstart(today(),-1))) <=$(=date(quarterend(today(),-1)))"}, >} UNIT.TOTALSOLD)

Anonymous — Thu, 12 Nov 2015 09:50:05 GMT

Amazing! Thank you Mayil!!!

Anonymous — Thu, 12 Nov 2015 09:53:37 GMT

Remove Comma in last, try this:

sum({<UNIT.SOLD_DATE = {'>=$(=date(quarterstart(today())))-1 <=$(=date(quarterend(today())))-1'} >} UNIT.TOTALSOLD)

Also make sure UNIT.SOLD_DATE, have same format as Today(), if format of both the date mismatch, it wud not give you anything