topic Re: Sort Order in a QoQ bar chart in QlikView

Sort Order in a QoQ bar chart

Anonymous — Mon, 10 Jul 2017 08:31:39 GMT

Dear all,

I try to create a bar chart with a Quarter over Quarter and Year over Year comparison.

The below Screenshot is displaying the current status of my development.

Currently I stuck at two points:

a) The sort order of the Bars, the sorting should start on the right side with the last full Quarter Q2 - 2017 compared with Q2 - 2016 to the left ending with Q3 - 2016 compared with Q3 - 2015.

b) Hiding the empty Year Bars in the chart

Until now I tried to solve this with the default Sorting settings.

Is there a way to solve my questions within QlikView or do I have to setup a "special" Dimension in the Script?

Many thanks in advance and best regards,

Claus

Re: Sort Order in a QoQ bar chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 08:35:27 GMT

I assume, You need Dual() function in the script itself as you are not aware we can not make as 2 dimensions with as need

Re: Sort Order in a QoQ bar chart

Anonymous — Mon, 10 Jul 2017 09:56:52 GMT

Many thanks for your hint. Indeed, the DUAL function could help to solve the sort question.

I'll check this out...

Re: Sort Order in a QoQ bar chart

Anonymous — Tue, 29 Aug 2017 13:41:39 GMT

Dear all,

Unfortunately until now I wasn't able to solve this question.

I tried a lot of things but nothing worked sufficient for me.

I attached a sample qvw where I tried to sort the Quarters by a YEAR-QUARTER DUAL field.
But the result is always the same... the sort order is not as expected.

Q3 has the oldest data but the Quarter is always displayed as last Quarter.
The expected sort order should be from left to right "Q3", "Q4", "Q1" and "Q2".

And it makes no difference if I hide the YEAR Dimension or not.

Maybe someone has an idea to solve this?

Many thanks in advance and best regards,

Claus

Re: Sort Order in a QoQ bar chart

sunny_talwar — Tue, 29 Aug 2017 14:09:52 GMT

Try this

=Max({<DATE={"<=$(=QuarterEnd(Max(DATE), -2))"}>}DATE)

Re: Sort Order in a QoQ bar chart

Anonymous — Tue, 29 Aug 2017 14:23:35 GMT

Dear Sunny,

Many thanks for your reply. Your solution solves my question totally!

Sorting by date with a limitation of the displayed Quarters looks so easy now... 🙂

Best regards,

Claus