Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({$<TS_year *= {2013}>} TS_hoursWorked)
Thanks so much Sunny! Works like a charm!