topic Re: Need help sorting in a bar chart in QlikView

Need help sorting in a bar chart

Tue, 26 Mar 2013 05:34:29 GMT

Hello Friends

I have bar chart the dimetionn is Product and the expressions are like

Networking days(Start_Date - Process_Date),

Netwroking days (Process_date - Final_Date) and

Networking Days(Final_Date - End_Date)

I don't know how to sort the higest combined of all in a decending order.

Could you please suggest a solution for this.

Regards

Chriss

advait_thakur — Tue, 26 Mar 2013 05:40:03 GMT

Hello Chriss,

To achieve the same you need to go to the properties of bar chart.

Go to the Sort tab and choose your dimension and click on Numeric Value.

Choose Descending in order.

May be this is the solution you are looking for.

Thanks

Advait

Tue, 26 Mar 2013 05:55:58 GMT

Hi Advait,

Thanks for your reply, I tried all the options in the sort but its not coming as what I expected.

in the Sort/ expression option I tried Max(

(Start_Date - Process_Date) or

(Process_date - Final_Date) or

(Final_Date - End_Date)) but the output is wrong.

can you please suggest any workaround.

Regards

Chriss

advait_thakur — Tue, 26 Mar 2013 06:48:45 GMT

Hello Chirss,

First of all you cannot display sort on all three expressions.

Will you please let me know on what format your date is coming ?

Also try to convert the date in numeric value and then perform the sorting which will be the easy way.

In the meantime will you please try sorting on Y axis by going to the properties.

Thanks

Advait

Tue, 26 Mar 2013 09:42:28 GMT

Hello Advait,

Thanks for your help, now its working fine...

Regards

Chriss