Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

monthname in set analysis

Hi,

What's wrong with this expression

=sum({<MonthName(Date)={'$(=MonthName(Today())'}>}[Amount)

Regards

Saurabh

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

It is not possible to use the Function like you did.

Instead you should create a field MonthName(Date) in Script like below.

Load *,MonthName(Date)  as MonthYear From XYZ;

And then use below expresssion.

=sum({<MonthYear={'$(=MonthName(Today())'}>}[Amount)


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

It is not possible to use the Function like you did.

Instead you should create a field MonthName(Date) in Script like below.

Load *,MonthName(Date)  as MonthYear From XYZ;

And then use below expresssion.

=sum({<MonthYear={'$(=MonthName(Today())'}>}[Amount)


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!