topic Re: Date sorting in previous year comparison bar chart. in QlikView

Date sorting in previous year comparison bar chart.

dpstanley_13 — Wed, 02 Mar 2016 14:06:34 GMT

I have a chart that compares a 30 day range to the same 30 day range from the previous year. Currently the chart looks like this:

Green = 2015

Beige = 2016

I really want the bars for the same month and day placed next to each other, instead of the the group of dates showing for one year and than the other. My dimension is simply a date. Is there an expression that I can sort on to achieve what I want, or is there another approach all together?

Re: Date sorting in previous year comparison bar chart.

sunny_talwar — Wed, 02 Mar 2016 15:26:09 GMT

Change your dimension from date to a calculated one -> Date(Date#(SubField(DateField, '/', 1) & '/' & SubField(DateField, '/', 2), 'M/D'), 'M/D')

Re: Date sorting in previous year comparison bar chart.

dpstanley_13 — Wed, 02 Mar 2016 17:41:57 GMT

I ended up using a similar concept without forcing it as a date, as this seems to break my set analysis. I used Num(Month(DateField),'00')&Num(Day(DateField),'00').

Re: Date sorting in previous year comparison bar chart.

Colin-Albert — Wed, 02 Mar 2016 17:44:17 GMT

Use Day(YourDateField) as your dimension instead of YourDateField.

Day gives the day of the Month (1-31)