topic Re: Re: Sort order in a Line Chart with a circular dimension in QlikView

Sort order in a Line Chart with a circular dimension

danialier — Mon, 19 May 2014 14:20:25 GMT

Hello !

I have a Line Chart showing revenue for two SKUs. In the x axis I have the period in month and quarters using a circular dimension so I can jump to a quarterly or monthly view based on my needs.

The issue came on the x axis sorting, because i did not find the way to have both month and quarter well sorted.

Please help. I'm attaching a sample on what I have.

thks,dani

Re: Sort order in a Line Chart with a circular dimension

marcus_sommer — Mon, 19 May 2014 15:01:07 GMT

You need numeric values for this kind of sorting. I suggest you add a numeric month and quarter field to your datamodel or creates your period-fields with dual(string, number).

Alternatively you could use a sorting-expression (tab sort) with pick(match()) or makedate(year, month, day) or similar.

- Marcus

Re: Re: Sort order in a Line Chart with a circular dimension

maxgro — Mon, 19 May 2014 20:26:09 GMT

hope to understand, see attachment

I sorted the 2 dim of the cyclic dimension

Re: Sort order in a Line Chart with a circular dimension

Mon, 19 May 2014 20:52:57 GMT

Hello,

As Marcus said, you need convert Month-Year field in numeric value, to do this, first use makedate() to get a correct Date, then just get Numeric Period (Year/Month) with MonthName() , finally just create your gruop and use Calendar Quarter sorted by A-> Z ASC and Period (Month/Year) sorted by Numeric Value ASC and thats all.

Best regards.

See attached file.