Using variable in SET analysis

Anonymous — Mon, 13 Jun 2016 10:20:14 GMT

Hi all,

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:

set vmonth_1=(year(today()))&'_'&(month(today())-1);

Now, i am writing set analysis for this:

sum({<month={'$(=vmonth_1)'}>} amount)

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.

Thanks

Re: Using variable in SET analysis

swuehl — Mon, 13 Jun 2016 10:36:11 GMT

Try

LET vmonth_1=(year(today()))&'_'&(month(today())-1);

Now your variable should hold 2016_5

Then:

sum({<month={'$(vmonth_1)'}>} amount)

edit: Please note that your variable will probably not create the correct value in January.

Anonymous — Mon, 13 Jun 2016 11:16:29 GMT

oh yes!

Thanks!