Sorting

[#1]

these are the values

<100k

100k-250k

250k-1M

1M-3M

3M+

ENN

NHH

and I want them to appear in the same manner in the people chart

but the sorting isn't working.

I tried adding 1,2,3 numbers before these and sort them numerically but it is still not working

any way I can get this done?

[sunny_talwar]

Where are you using this? You can use Dual function to assign these numerical values if you want

[#3]

People chart

How to use Dual Function?

These are the values that are there in excel data sheet but they appear in random order.

I want them to be in this order strictly

[sunny_talwar]

Something like this:

Dual(FieldName, Match(FieldName, '<100k', '100k-250k', '250k-1M', '1M-3M', '3M+', 'ENN', 'NHH'))

[sunny_talwar]

What is a people chart? I have never seen it before?

[#6]

[reddy-s]

Hi Sagarika,

If you have numbers for each of the values in your data model, you can use that filed in the "sort by expression" property in the properties panel.

[#8]

yes I have numbers. for ex: <100k I have some 40K people again for 100k-250k I have 50k people and so on.

I have tried using sort by expression

what code shall I use in the expression exactly?

I have tried everything

if, match, dual etc

[reddy-s]

HI Sagarika,

Is it possible to share your qvf?

[arulsettu]

may be try like this

load * inline [

filedname,s_no

<100k,1

100k-250k,2

250k-1M,3

1M-3M,4

3M+,5

ENN,6

NHH,7

];

in sort by expression give  s_no