Solved: monthname in set analysis - Qlik Community - 1128177

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hi,

What's wrong with this expression

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

Regards

Saurabh

1 Solution

Accepted Solutions

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

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!