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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
salleninsd
Creator
Creator

Past 3 Months Expression

Hello, rookie question:

I am trying to have a graph that shows a timeline of the past 3 months and am using the following expression.  When I break the expression into singular parts, they work fine (as indicated in the blue text boxes).  I selected dual MonthAbbr in the load script, and my graph indicates "No Data to Display".  Am I writing the following script in the correct syntax?  I am using the personal version of QlikView, so I cannot attach the file.  Any feedback is appreciated!  Thank you!

sum({$<MonthAbbr={'>=$(=Max(MonthAbbr)-2) <=$ (=Max(MonthAbbr))'} > } SalesAmount)

Section 10 Lesson 76 dual MonthAbbr5.PNG

Labels (1)
3 Replies
jwjackso
Specialist III
Specialist III

I believe the $ expansion uses double quotes.  See this blog The Magic of Dollar Expansions

salleninsd
Creator
Creator
Author

Hey Jerry!  Thank you so much... it worked for me.  I really appreciate your help!!!

shiveshsingh
Master
Master

Try this

sum({$<MonthAbbr={">=$(=Max(MonthAbbr)-2) <=$ (=Max(MonthAbbr))"} > } SalesAmount)