topic Re: ordering categories in a graph in QlikView

ordering categories in a graph

Tue, 10 Jan 2012 07:52:09 GMT

Hi....

does anyone know how I can give a personalized order to columns in a chart?

I found only other ordering criteria such as alphabetic order, numbers....

In this case I need to order the second dimension of a chart.

the order should be "rete"-"prodotto"-"servizi"-"marchio"...

Any idea?

Thank you very much in advance for your help!

Bye

Silvia

Re: ordering categories in a graph

Tue, 10 Jan 2012 10:05:56 GMT

Hi Silvia,

if you got a individuel sort order for a field, you can create an additional table containing the according field and a order-field to use it for sorting in your charts.

Check out the second chart in my little example app. The Column Name is sorted by expression --> Field Sortorder

HtH

Roland

Re: ordering categories in a graph

Wed, 11 Jan 2012 08:13:51 GMT

unfortunately with the free edition I cannot open the file you attached to your message....

anyway, I try to follow your instructions.

Thank you so much!

Bye Silvia

Re: ordering categories in a graph

Wed, 11 Jan 2012 09:04:24 GMT

Hi again,

here is the load-script snippet.

DimTable:

LOAD * Inline [

Name, Prename, Val

marchio, Reste, 100

rete, Alfonso, 200

prodotto, Amalia, 300

servizi, Guiseppe, 400

];

SortTable:

LOAD * Inline [

Name, SortOrder

rete, 1

prodotto,2

servizi,3

marchio,4

];

After loading build for ex. a straight table chart with Dims = Name and Prename and

a simple expression like sum(Val).

In sort tab check "Sort By Expression" for Name and put in "SortOrder" into expression editor.

If you got problems with it, post your app. People with an fully licenced version can open it