
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Make sure that you have '=' sign before the variable definition.
So the variable should hold. "=MonthName(Today(1))"
Regards,
Kaushik Solanki

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please share a sample app? with this? To diretly test on it?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Heres a sample app with data loaded.
Thanks
Martin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's working for me :
