A Table Calculates based on variable input

[samuel_lin]

hi qlikkers!

for Qliksense, is it possible that a table's calculation is based on an input?

for example, this table

is for the month of December, the first column is the month's actual, second column is vs. last year (same period)... and so forth.

basically that I hope, if I choose "December", then this table will reflect December,

if I choose "November", then this table will reflect November; second column will be vs. Nov ly.

Any way that this could be done in sense?

Thanks,

Samuel

[#2]

If your field is call Month then in your set expression you could add this string:

Month=p(Month)

This will change the month(s) you are evaluating based on the selections of the Month field.

This post might help you with year manipulation in set analysis:  Set analysis to find current year, year-1, year-2