Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Add a sorting below sorting table.
LOAD * INLINE [
and then added Sort Field in the Expression as shown in the screen shot.
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.
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;
Waiting for reply!
@ Ruben: I have no access to download and upload .qvw file in office due to security reasons.
Hi, and paste a screenshot of the sort tab?
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!