topic Re: Issue with sorting the text in bar chart in QlikView

Issue with sorting the text in bar chart

Wed, 25 Nov 2020 16:16:04 GMT

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

Please help me out

Re: Issue with sorting the text in bar chart

robert_mika — Wed, 23 Nov 2016 17:08:29 GMT

use sort by Y-value

Re: Issue with sorting the text in bar chart

Wed, 23 Nov 2016 17:15:54 GMT

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

Re: Issue with sorting the text in bar chart

eromiyasimon — Wed, 23 Nov 2016 17:34:15 GMT

i cant see you,

kindly upload your sample QVW

Re: Issue with sorting the text in bar chart

Gysbert_Wassenaar — Wed, 23 Nov 2016 17:41:42 GMT

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.

Re: Issue with sorting the text in bar chart

rupamjyotidas — Wed, 23 Nov 2016 18:18:50 GMT

Use Dual(employee,Count)
in

Re: Issue with sorting the text in bar chart

Wed, 23 Nov 2016 19:18:27 GMT

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

Re: Issue with sorting the text in bar chart

Wed, 23 Nov 2016 19:19:53 GMT

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

Re: Issue with sorting the text in bar chart

Gysbert_Wassenaar — Thu, 24 Nov 2016 06:31:37 GMT

Establishing a Sort Order | Qlikview Cookbook

Re: Issue with sorting the text in bar chart

jonathandienst — Thu, 24 Nov 2016 06:53:52 GMT

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...

Re: Issue with sorting the text in bar chart

Thu, 24 Nov 2016 18:37:21 GMT

its not working Gysbert

Re: Issue with sorting the text in bar chart

Gysbert_Wassenaar — Fri, 25 Nov 2016 06:58:16 GMT

Post a Qlikview document that demonstrates the problem and we will show you how to fix it.

Re: Issue with sorting the text in bar chart

Fri, 25 Nov 2016 18:42:58 GMT

Hi Gysbert, below is my application, where i'm facing the problem and i had explained it in the text objects in the application.

Please help me out

Re: Issue with sorting the text in bar chart

Fri, 25 Nov 2016 18:44:19 GMT

Hi Jonathan, below is my application, where i'm facing the problem and i had explained it in the text objects in the application.

Please help me out

Re: Issue with sorting the text in bar chart

Gysbert_Wassenaar — Sun, 27 Nov 2016 18:07:00 GMT

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

Re: Issue with sorting the text in bar chart

Mon, 28 Nov 2016 18:31:01 GMT

Hi Gysbert, can you please help me out in this requiremnt please

calculating values using >,< symbols and inputbox