Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I believe the $ expansion uses double quotes. See this blog The Magic of Dollar Expansions
Hey Jerry! Thank you so much... it worked for me. I really appreciate your help!!!
Try this
sum({$<MonthAbbr={">=$(=Max(MonthAbbr)-2) <=$ (=Max(MonthAbbr))"} > } SalesAmount)