Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pranaview
Creator III
Creator III

Using MonthName function in a set expression is not working as expected

Hi Guys,

I have to get average of records for last 3 months. I was using below logic to get it but am not getting correct result.

=Avg({<MonthYear ={$(=MonthName(Addmonths(today(),-1))),$(=MonthName(Addmonths(today(),-2))),$(=MonthName(Addmonths(today(),-3)))}>}Field)

where the expression =MonthName(Addmonths(today(),-1)) will give you Dec 2018 and MonthYear field is MonthName(Date)

I think it's because of the $ expansion there might be something going wrong but i am not sure. 

Although when I use the following expression, i get the correct result.

=Avg({<MonthYear = {"=MonthYear =MonthName(Addmonths(today(),-1))","=MonthYear =MonthName(Addmonths(today(),-2))","=MonthYear =MonthName(Addmonths(today(),-3))"}>}Field)

I know i could have just used the second expression but I am curious why the first one did not work or is there any better solution to this problem than second expression.

Any input would be appreciated.

Cheers,

Pranav

 

Labels (3)
1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

You will need quotes as well.

=Avg({<MonthYear ={"$(=MonthName(Addmonths(today(),-1)))",
"$(=MonthName(Addmonths(today(),-2)))",
"$(=MonthName(Addmonths(today(),-3)))"}>} Field)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner
Partner

You will need quotes as well.

=Avg({<MonthYear ={"$(=MonthName(Addmonths(today(),-1)))",
"$(=MonthName(Addmonths(today(),-2)))",
"$(=MonthName(Addmonths(today(),-3)))"}>} Field)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

pranaview
Creator III
Creator III
Author

Hi Jonty,

Thanks for the tip. Worked like a charm. Classic case of "Why didn't I think of that".

Regards,
Pranav