topic Sorting in QlikView

Sorting

Tue, 16 Sep 2014 07:17:54 GMT

Hi,

I have a calculated dimension whoch contains Month and Year fields concatenated together. Month field has values starting from Jan to Dec whereas Year field has values from 2013 onwards. My calculated dimension has values Jan 2013 and so on.

How do i sort theses values on the x axis of the chart so that i get values arranged properly e.g starting from Jan 2013 to Dec 2014.

Thanks

Re: Sorting

Anonymous — Tue, 16 Sep 2014 07:34:35 GMT

Hi Asma,e

You can concatenate month with year in the script like as " month & year" as MonthYear

then you can pass this in dimention in chart in sort tab select the MonthYear and check enable 'load order' then you can get the monthyear field in the order.

Hope this would be helpful for u.

Thanks

Re: Sorting

Tue, 16 Sep 2014 07:39:19 GMT

Write sort expression based on table fields.

Re: Sorting

ashfaq_haseeb — Tue, 16 Sep 2014 07:39:28 GMT

Hi,

use this in your script

MonthName(yourdatefield) as Monthyear,

It will give you month and year together the way you are looking at, and it will be sorted.

Regards

ASHFAQ

Re: Sorting

MK_QSL — Tue, 16 Sep 2014 08:04:53 GMT

Considering that the Date field which you are using for your Calculated Dimension is named as Invoice Date....use below formula to create MMM YYYY ...

Calculated Dimension

=DUAL(Date(MonthStart([Invoice Date]),'MMM YYYY'),Date(MonthStart([Invoice Date]),'YYYYMM'))

Expression

SUM(Sales)

or whatever as per your datamodel...

Using this, you can now sort the MonthYear field as Numeric field...