Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

durgabhavani
Contributor

Re: Help me in sorting the order of legend?

Ruben, I am implemented as above only, may be due to caliculated dimension it is not giving correct output.

i am getting correct order in listbox but not getting in dimension legend for piechart.

Thanks,

Durga

Not applicable

Re: Help me in sorting the order of legend?

Hi Durga,

Add a sorting below sorting table.

SortingTable:

LOAD * INLINE [

dayscheck, Sort

0-10 Days,1

11-30 Days,2

31-50 Days,3

51-70 Days,4

70+ Days,5];

and then added Sort Field in the Expression as shown in the screen shot.Durga.jpg

Re: Help me in sorting the order of legend?

Hi durga, can you check in the sort tab if the dimension is sorted by number (not alphabetical)

Manish, Rudolf and Rupas solutions also should work, so it can be something to do with calculated dimension or other options messing, but without a sample is hard to guess, please upload a sample.

durgabhavani
Contributor

Re: Help me in sorting the order of legend?

Rupas,

I have already written below script in edit script to get "dayscheck" field, so how can i change to your way to call variable 'sort' in expression tab.

Details:
LOAD *,
if(length <= 10, Dual('0-10 Days',1),
if(length <= 30, Dual('11-30 Days',2),
if(length <= 50, Dual('31-50 Days',3),
if(length <= 70, Dual('51-70 Days',4),Dual('70+ Days',5))))) as dayscheck

resident temp;
drop table temp;

Please advice1

Waiting for reply!

@ Ruben: I have no access to download and upload .qvw file in office due to security reasons.

Thanks,

Durga

Highlighted

Re: Help me in sorting the order of legend?

Hi, and paste a screenshot of the sort tab?

durgabhavani
Contributor

Re: Help me in sorting the order of legend?

Ruben, when i click on numeric order it diplayed correctly.

Rupes wonderful explination.

Manish/ Rudolf thank you very much for all your support!

Thanks a ton for all!

Durga.

Community Browser