Qlik Community

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 
Search instead 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

   

employeecount
MI8
ME7
BO6
CA6
CI6

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

Please help me out

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

15 Replies
robert_mika
Master III
Master III

use sort by Y-value

Capture.PNG

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

eromiyasimon
Creator II
Creator II

i cant see you,

kindly upload your sample QVW

Gysbert_Wassenaar

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
rupamjyotidas
Specialist
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)

please hekp me out

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

Gysbert_Wassenaar

Establishing a Sort Order | Qlikview Cookbook


talk is cheap, supply exceeds demand
jonathandienst
Partner
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