Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

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)