topic Help in sorting bar chart dimension field in QlikView

Help in sorting bar chart dimension field

Wed, 08 Dec 2010 12:09:30 GMT

Hi All,

I want to sort the below one which is there in one of my bar chart like the one which is given after that. Also have given the dimension for your reference.

Orginal one:

Wants to sort like this:

Dimension:

=right(START_YEAR,2)&'-'&STARTPERIOD

Help in sorting bar chart dimension field

Thu, 09 Dec 2010 01:58:55 GMT

Looks like you have flip flopped the period and the year

=right(START_YEAR,2)&'-'&STARTPERIOD

=STARTPERIOD&'-'&right(START_YEAR,2)

If you have the dismension displaying the way you want with P#-YY but you want sorted by YY-P# just use Sort By Expression and plug in one or the other expressions from above.

Help in sorting bar chart dimension field

Thu, 09 Dec 2010 06:36:31 GMT

Thanks for your help your help. I already tried that but it didn't give the expected result.

Help in sorting bar chart dimension field

Thu, 09 Dec 2010 06:51:54 GMT

Hi ,

I suggest you to use " WILDMATCH " function in Sort - expression .

You have to define all ur periods sequencially & then make sort order "Ascending" . U will get result.

Bhushan N

Help in sorting bar chart dimension field

Thu, 09 Dec 2010 06:58:11 GMT

Yes got the result!