Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

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

Hi Experts

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

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

Regards

Av7eN

4 Replies
Anonymous
Not applicable

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
Specialist III
Specialist III
Author

Need Suggestions????

Anonymous
Not applicable

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

giakoum
Partner - Master II
Partner - Master II

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

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