topic Re: comparing periods in QlikView

comparing periods

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I would like to compare the number of clients that made reservation in the last 30 days to the parallel time (between 30-60 days ago).

I tried using set analysis (below) to calculate number of clients who made a reservation in the last 30 days but it didn't work.

I tried in 2 ways:

=count({<RsvDate={"<$(vToday) >$(vToday)-30"}>}AgencyID)

i also created a variable vToday which is = today()

tried to do this using today() function instead of variable

=count({<RsvDate={"$(<today()) $(>today()-30)"}>}AgencyID)

Appreciate your help, using this set analysis or in any other way (not in the script)..

thanks,

Naama

sunny_talwar — Tue, 06 Dec 2016 10:33:20 GMT

Do you have RsvDate as your dimension and are you hoping to see these two numbers in the same row?

sunny_talwar — Tue, 06 Dec 2016 10:34:53 GMT

Also, try these:

=Count({<RsvDate={"$(='<' & Date(vToday, 'DateFieldFormatHere') & '>' & Date(vToday-30, 'DateFieldFormatHere'))"}>} AgencyID)

vinieme12 — Tue, 06 Dec 2016 10:40:34 GMT

or create the date buckets in your load script , <30 , 30-60 etc and use these in your Set expression