topic Re: How do I get the current MonthYear on a chart? in QlikView

How do I get the current MonthYear on a chart?

Wed, 20 Feb 2013 12:05:57 GMT

I attended the Qlikview developer training last week and have been having a play with the file we created. However I am having trouble trying to get the current MonthYear on a chart.
We added the master calendar at the training so the script should be ok.
I can get it to work for just the year, so if I use the expression:
sum({$<Year = {$(=max(Year))}>}LineSalesAmount)
it works fine.
However if I use the expression:
sum({$<MonthYear = {$(=max(MonthYear))}>}LineSalesAmount)
then the chart goes blank.
What am I doing wrong?

Re: How do I get the current MonthYear on a chart?

Wed, 20 Feb 2013 12:10:30 GMT

Send me the Sample Application

Re: How do I get the current MonthYear on a chart?

Wed, 20 Feb 2013 12:14:02 GMT

Here it is, it's the same one they use at the training.

Re: How do I get the current MonthYear on a chart?

Thu, 21 Feb 2013 14:06:07 GMT

Anybody?

I would have thought this would be quite simple.

Re: How do I get the current MonthYear on a chart?

giakoum — Thu, 21 Feb 2013 14:20:32 GMT

Year is a number, MonthYear is not.

So you need to use single quotes to make it work :

sum({$<MonthYear = {'$(=max(MonthYear))'}>}LineSalesAmount)

Double qoutes also work as QlikView consideres it as a search.

Re: How do I get the current MonthYear on a chart?

Thu, 21 Feb 2013 14:36:12 GMT

Thank you for responding Ioannis.

However, the expression you gave still returns a blank and if I use double quotes instead it also returns a blank.

Re: How do I get the current MonthYear on a chart?

giakoum — Thu, 21 Feb 2013 14:43:16 GMT

It does return values. See attached, green column in chart

Re: How do I get the current MonthYear on a chart?

Thu, 21 Feb 2013 14:52:12 GMT

Sorry Ioannis, not sure what I did to make it not work but can see it does now.

Thanks a lot for your help