topic Re: Day wise Current Month & Last Month Comparison...........?? in QlikView

Day wise Current Month & Last Month Comparison...........??

aveeeeeee7en — Mon, 23 Mar 2015 09:03:52 GMT

Hi Experts

I need some help on Comparative Analysis............!!

Please go through the Attachment to see my Requirement.....????

Regards

Av7eN

Anonymous — Mon, 23 Mar 2015 10:24:52 GMT

so you basically want to see last 4 weeks no matter month and date etc right ?

I think you can use

date greater than equal to monthstart(today())-28 and less than monthstart(today())

for previous months data

regards,

Bhagirath

aveeeeeee7en — Mon, 23 Mar 2015 11:07:31 GMT

Need Suggestions????

Anonymous — Mon, 23 Mar 2015 11:30:07 GMT

=SUM({<Date={'<$(dayname(monthstart(today())))'},Date={'>=$(dayname(monthstart(today())-28))'},Date=,MonthYear=>}Amount)

giakoum — Mon, 23 Mar 2015 11:33:59 GMT

Bhagirath gave you the solution. What more do you need?

=SUM({<Date={'>=$(=monthstart(today())-28)<=$(=monthstart(today()))'}>}Amount)