topic Re: Set Analysis - Compare dates in QlikView

Set Analysis - Compare dates

Anonymous — Thu, 13 Aug 2015 11:42:49 GMT

I have a line graph showing a count of data per hour of the day. I want to compare this to the value 7 days previous

I've used the following:

=count({<CorrectedDate={$(=(Max(CorrectedDate)-7))}>} Hour)

However, it isn't showing the 7 days previous figure on the line graph. Have I missed something?

MK_QSL — Thu, 13 Aug 2015 11:49:23 GMT

Count({<CorrectedDate = {'$(=Date(Max(CorrectedDate)-7))'}>}Hour)

sasiparupudi1 — Thu, 13 Aug 2015 11:58:33 GMT

may be you have other selections that needs to be ignored?

count({<month=,year=,day=,CorrectedDate={$(=(Max(CorrectedDate)-7))}>} Hour)

hth

Sasi

sunny_talwar — Thu, 13 Aug 2015 12:01:38 GMT

May be this:

=Count({<CorrectedDate={"$(=Date(Max(CorrectedDate)-7), 'YourDateFormat')"}>} Hour)

sasiparupudi1 — Thu, 13 Aug 2015 12:31:11 GMT

Hi Sunny,

You meant this?

Count({<CorrectedDate={"$(=Date(Max(CorrectedDate)-7, 'YourDateFormat'))"}>} Hour)

Anonymous — Thu, 13 Aug 2015 13:00:51 GMT

Tried all answers. Still not showing the 2nd line

MK_QSL — Thu, 13 Aug 2015 13:02:08 GMT

Post sample application pls

sunny_talwar — Thu, 13 Aug 2015 13:16:39 GMT

Yup, that is what I meant