class/Rank/group - Qlik Community

Anonymous · ‎2015-05-28

Hi,

i need the sorting order for the particular range

please find the attachements

!

Anonymous · ‎2015-05-28

Suggestions pls

danieloberbilli · ‎2015-05-28

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 · ‎2015-05-28

Hi...

In which order you want to sort.

Means first you want text or number.

Anonymous · ‎2015-05-28

i need them like this

RangeOfSales

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

Anonymous · ‎2015-05-28

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

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

danieloberbilli · ‎2015-05-28

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 · ‎2015-05-28

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 · ‎2015-05-28

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

robert_mika · ‎2015-05-28

Look at Dual function

How to use- Dual()

Still manual input thru...