Current to Previous Year Comparision

Anonymous — Wed, 25 May 2016 11:00:37 GMT

Hi All,

I have a data set that I need to report in a combo chart, whereby the bar section will display the current years data, and the line section will display the previous years data for the same selection.

In terms of selection options, I can select year and country, so if i select 2016 and the UK, the chart should display the 2016 data in bar format and the 2015 data in line format, arranged in ascending order by week number.

The issue I have is that whist the current year's data displays correctly following the week numbers on the X axis, the previous years data, is bunching exactly in the middle of the chart instead of following the week numbers.

The expression definition I have used for the previous year is as follows:

'sum({$<Calendar.YL_Tax_Year_Short = {$(#=Only(Calendar.YL_Tax_Year_Short)-1)}>} PltEquivDel )'

It seems to be puling the correct data just not displaying it correctly, any help would be much appreciated.

Thanks

topic Current to Previous Year Comparision in QlikView

Current to Previous Year Comparision