Discussion board where members can get started with Qlik 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.
The expression is working in qlikview but not sense.
Go to Solution.
It's working for me :
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:
Make sure that you have '=' sign before the variable definition.
So the variable should hold. "=MonthName(Today(1))"
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?
Can you please share a sample app? with this? To diretly test on it?
Heres a sample app with data loaded.