topic 1st Day Problem in QlikView

1st Day Problem

narender123 — Fri, 02 Aug 2013 06:25:00 GMT

Hi Team,

=Sum({<Year={$(=Max(Year))},Month={$(=MaxString(Month))},Day={$(=Day(Today()-1))}>}amount)

its working for all date but when day=1 of August

then it will give 0

As per the logic it should return 31 july amount but its showing 0.

Please give me some idea.

Thanks in Advance.

Narender

Re: 1st Day Problem

tresB — Fri, 02 Aug 2013 06:29:59 GMT

i guess, it's because your previous date is falling in another month and you have taken the max month in the set. I suggest, use date field rather than day.

Re: 1st Day Problem

Fri, 02 Aug 2013 06:39:45 GMT

Why not use

=Sum({<Year={$(=Year(Today() - 1))},Month={$(=Month(Today() - 1))},Day={$(=Day(Today()-1))}>} amount)

But as tres says its best to use Date field instead.