# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Not applicable

## Issue with sorting the text in bar chart

Hi All i'm facing  a problem

This is my table box where, i sorted the values and its working fine as expected.

first based on count it should sort

Next based on alphabetical order i should sort

its working fine in the table box

 employee count MI 8 ME 7 BO 6 CA 6 CI 6

when coming to bar chart the case is different

The same dat when i'm converting into a bar chart,

its displaying in other order because of the duplicate counts

I have checked the Sort by A-Z as well but no luck

1 Solution

Accepted Solutions

It's the Dimension Limits that are causing this. Try this expression: sum({<country={"=rank(sum(orders),4)<5"}>}orders)

talk is cheap, supply exceeds demand
15 Replies
Master III

use sort by Y-value

Not applicable
Author

Hi Robert,

I have two dimensions here one is month and next is employee

In the second dimension i cnat able to sort by y value

Creator II

i cant see you,

You can change the sort order in the script of the employees. Create a small table that loads the employees sorted in the order you want. That will determine the load order of the employees. Once you done that you can load the other data and finally drop the table you created to sort the employees. Then you can sort the chart by Y-value and the employees will be sorted by their load order in the order you defined in the script.

If you don't want to change the script you will have to get quite creative with the Ord function on the first N characters to create a numeric value that indicates a sort order.

talk is cheap, supply exceeds demand
Specialist

Use Dual(employee,Count)
​in

Not applicable
Author

Hi Gysbert can u please provide me a sample code,

and in the sort tab i'm already sorting the expression, by the same expression i have written in the set expression

=count({<issammonth={'1'}>}employee)

Not applicable
Author

o already had an expression in this which gives me sorting by top to bottom values but not giving me alphabetical order sort

Establishing a Sort Order | Qlikview Cookbook

talk is cheap, supply exceeds demand
Partner

It looks like your chart is sorting correctly. From the legend, the dimension looks different from the table, but the duplicates are sorted correctly as:

Car...  Ela...    Fer...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein