Calculated Dimension?

[peterderrington]

I'm trying to create a line graph in QlikView to compare data across two years.

I have a dimension (DOA_Month) and an expression (AVG([Total LOS]) which shows me the length of stay across the months however this shows a combination of two years worth of data across the same months.

I can add a list box to pick a specific year (DOA-Year) but ideally i'd like to show both years (2016 and 2017 from the DOA-Year dimension) on the same graph.

I'm sure its easy to do but my brains just not working this morning.

Would i do this with a 'calculated dimension' or somewhere as an expression?

Many thanks in advance.

[Anonymous · Accepted solution]

Try AVG({<DOA-Year={'2016'}>}[Total LOS])

[peterderrington]

Brilliant!

Thank you. Its all showing exactly as i needed it.

Many thanks.