class/Rank/group

[Anonymous]

Hi,

i need the sorting order for the particular range

please find the attachements

!

[Anonymous]

Suggestions pls

[danieloberbilli]

as Qlik cant identify the value for a logic sorting order, you have to manually sort them: e.g. pre-load a table with the values in the correct sorting order, then load the real data and dropt the sorting table at the end.

Then you can use Load order in the Sorting tab of the chart object

SortOrder_tmp:
LOAD * INLINE [
    RangeOfSales
    less than  1k
    1k-2k
    3k-5k
    6k-9k
    10K-40K
    1.00-4.00
    5.00-900
    10.00-15.00
];


Rangeofsales:
LOAD * INLINE [
    SalesID, RangeOfSales
    s01, 10K-40K
    s02, less than  1k
    s03, 3k-5k
    s04, 1k-2k
    s05, 6k-9k
    s06, 1.00-4.00
    s07, 10.00-15.00
    s08, 5.00-900
];

DROP Table SortOrder_tmp;

[prajapatiamar38]

Hi...

In which order you want to sort.

Means first you want text or number.

[Anonymous]

i need them like this

RangeOfSales 

1.     less than  1k 
2.     1k-2k 
3.     3k-5k 
4.     6k-9k 
5.     10K-40K 
6.     1.00-4.00 
7.     5.00-900 
8.     10.00-15.00 

[Anonymous]

Danie, what if i have more values for that column?

conside row count around 1k? we cant do manually i guess

[danieloberbilli]

It only works, if you find some kind of 'logic' in the values to indicate Qlik how to sort...are there any other fields in your data source that might help?

[timanshu]

Hi,

Row count doesn't matter. but no of  range  will be less than 20 I think.

Define range in if else and that will work.

[Anonymous]

Hi timanshu could you help me out sharing some sample app on the same?

[robert_mika]

Look at Dual function

How to use- Dual()

Still manual input thru...