A Table Calculates based on variable input

samuel_lin — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: A Table Calculates based on variable input

Fri, 27 Jan 2017 18:54:33 GMT

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