topic Selections with Set Analysis in App Development

Selections with Set Analysis

Wed, 26 Jul 2017 12:42:46 GMT

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 — Wed, 26 Jul 2017 15:17:32 GMT

Try this

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

Wed, 26 Jul 2017 16:43:27 GMT

Thanks so much Sunny! Works like a charm!