Discussion Board for collaboration on QlikView Scripting.
I have a very basic doubt on using variable in SET analysis in Qliksense.
In table i have have three columns, as shown below:
I want to calculate sum of amount for last month (2016_5).
Now for this,
I am creating a variable which is year_month.
In script i created this variable as:
Now, i am writing set analysis for this:
but this statement doesn't seem to work and result shows as "-". I am really confused with this, appreciated if anyone can help me on this.
Go to Solution.
Now your variable should hold 2016_5
edit: Please note that your variable will probably not create the correct value in January.