Selections with Set Analysis

[#1]

Hi all,

I've got the following expression in Qlik sense to show years over months in a line chart:

Sum({$<TS_year={2013}>}(TS_hoursWorked))

This works fine, but if a user selects a year other that 2013, I want 2013 to disappear.

I've tried a if statement, but this doesn't work for a chart. With a if statement it only shows when the coded year is selected.

Any ideas?

Thanks,

Conrad

[sunny_talwar · Accepted solution]

Try this

Sum({$<TS_year *= {2013}>} TS_hoursWorked)

[#3]

Thanks so much Sunny! Works like a charm!