Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_lin
Creator
Creator

A Table Calculates based on variable input

hi qlikkers!

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

for example, this table

VariableInput.PNG

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

1 Reply
Not applicable

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