topic Re: Past 3 Months Expression in QlikView

Past 3 Months Expression

salleninsd — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Past 3 Months Expression

jwjackso — Sat, 17 Feb 2018 20:08:17 GMT

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

Re: Past 3 Months Expression

salleninsd — Sat, 17 Feb 2018 20:21:58 GMT

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

Re: Past 3 Months Expression

shiveshsingh — Sun, 18 Feb 2018 01:57:56 GMT

Try this

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