Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try AVG({<DOA-Year={'2016'}>}[Total LOS])
Brilliant!
Thank you. Its all showing exactly as i needed it.
Many thanks.