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: 
martin_hamilton
Creator
Creator

expression not working in sense

Hi - I am looking to port from qlikview to qliksense but a formula doesnt seem to be working.

I have a variable contained within the expression:

vCurrentMonth which has the following expression : MonthName(Today(1))

I have inserted the expression within a text box and its working as expected but within the following its not pulling the relevant data.

Sum({<Invoice_Month={'$(vCurrentMonth)'}>}Subs_Invoice_Amount)

The expression is working in qlikview but not sense.

thanks

Martin

1 Solution

Accepted Solutions
OmarBenSalem

It's working for me :

Capture.PNG

View solution in original post

6 Replies
OmarBenSalem

Where is it calculated? In the script?

If it's in the script, this should work since it's calculated with a '=',

If it's not in the script add a '=' to your variable.

=MonthName(Today(1)) instead of MonthName(Today(1))


Or, keep it without a '=' and add it when you call the variable:

Sum({<Invoice_Month={"$(=vCurrentMonth)"}>}Subs_Invoice_Amount)

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Make sure that you have '=' sign before the variable definition.

So the variable should hold. "=MonthName(Today(1))"

Regards,

Kaushik Solanki

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

This is calculated in the front end and still doesnt work when i make the changes.

Would it be different when using qliksense? as this works fine in qlikview?

thanks

Martin

OmarBenSalem

Can you please share a sample app? with this? To diretly test on it?

Thanks

martin_hamilton
Creator
Creator
Author

Heres a sample app with data loaded.

Thanks

Martin

OmarBenSalem

It's working for me :

Capture.PNG