topic Re: Sorting in bar chart in QlikView

Sorting in bar chart

Wed, 01 Apr 2015 18:40:56 GMT

Hi all,

I have month file(Jan,feb...dec) order....but my requirement is I need sep,oct,nov,dec,jan and feb order in bar chart.

please help me.

Re: Sorting in bar chart

MK_QSL — Wed, 01 Apr 2015 19:55:56 GMT

Got to Sort Tab

Tick Expression

Write Below in Expression Definition

=Only({1}Match(UPPER(Month),'SEP','OCT','NOV','DEC','JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG'))

Re: Sorting in bar chart

Anonymous — Wed, 01 Apr 2015 20:02:04 GMT

Calendar starts in October? When creating month in the script, use dual this way.

dual(month(Date), if(month(Date)>=10, month(Date)-9, month(Date)+3)) as Months

Now you can sort Month by numeric value, October will be 1 and September is 12

Edit: Just noticed it starts in September, that is

dual(month(Date), if(month(Date)>=9, month(Date)-8, month(Date)+4)) as Months

Re: Sorting in bar chart

pokassov — Wed, 01 Apr 2015 20:02:07 GMT

Hello!

You can use sort and write expression. If you have field in your calendar with data like "Apr 2014", you would use it.

In the other hand you can write your own expression like in my example.

Nevertheless, what have to do your chart, if you choose to years and equal months?

Sergey

Re: Sorting in bar chart

Fri, 17 Jul 2015 20:00:32 GMT

Use Mapping Load, ApplyMap and Dual

MONTH_SORT:

Mapping LOAD * INLINE

[

MNTH, SORT_NUM

SEP, 1

OCT, 2

NOV, 3

DEC, 4

JAN, 5

FEB, 6

MAR, 7

APR, 8

MAY, 9

JUN, 10

JUL, 11

AUG, 12

];

And use dual() where Month field is being loaded as below

Dual(Month,ApplyMap('MONTH_SORT',Upper(Month))) as Month

Regards,

KKR

Re: Sorting in bar chart

MarcoWedel — Fri, 17 Jul 2015 20:53:27 GMT

Hi,

another solution could be this sorting expression:

=Mod(Month-9,12)

hope this helps

regards

Marco