Sorting

[smilingjohn]

Hi All,

Please find the ttachment of the QVW file .

I have a filed called filter ... and i am going to use it as filter but i want the sorting order  like below

18.1

18.2

18.2

18.4

18.5

18.6

18.7

........ and so on ..Currently everything is combining very difficult to find the proper order

Please suggest some way

Thaks

[arvind_patil]

Hi John,

Please try below way it may help you

Data:

Load * Inline [

Data

18.1

18.2

18.2

18.4

18.5

18.6

18.7];

Load

mid(Data,4) as Sortnumber

Resident Data;

Exit Script;

Thanks,

Arvind Patil

[sunny_talwar]

Not sure I understand... your field contains more than just those numbers... how would you want the overall sort to look like?

[smilingjohn]

Hi sunny

Yes it has numbers as well as text .

But I want to display first ..

18.1

8.2

.

.

.and so on and then the text ..

Thanks

[MarcoWedel]

Hi,

try loading the field using the Text()‌ function:

hope this helps

regards

Marco

[qlikviewwizard]

marcowedel‌'s solution is working.

Load Filter,Text(Filter) as Filter_Text inline [

Filter

18.06

18.05

18.04

18.6

18.5

18.4

DAILY_OLL_CERTD_0508

DAILY_OLL_CERTD_0520

DAILY_OLL_CERTD_0530

DAILY_OLL_PKGE_0514

DAILY_OLL_CERTD_0524

DAILY_OLL_CERTD_0527

DAILY_OLL_CERTD_0507

DAILY_OLL_CERTC_0604

DAILY_OLL_CERTD_0604

DAILY_OLL_CERTC_0603

DAILY_OLL_CERTC_0605

DAILY_OLL_CERTD_0506

DAILY_OLL_CERTC_0607

DAILY_OLL_PKGE_0507

DAILY_OLL_PKGE_0508

DAILY_OLL_CERTD_0607

DAILY_OLL_CERTC_0524

DAILY_OLL_PKGE_0509

DAILY_OLL_PKGE_0513

DAILY_OLL_PKGE_0510

DAILY_OLL_PKGE_0506

DAILY_OLL_PKGE_0429

DAILY_OLL_PKGE_0503

DAILY_OLL_P220_0523

DAILY_OLL_PKGE_0430

DAILY_OLL_PKGE_0502

DAILY_OLL_PKGE_0501

18.3.05

18.6.2

Adhoc_03_WPIL_CERT

18.6.1

18.6_Sanity

1805_PUT14

DAILY_OLL_CERTC_0508

18.06.01

18.5.1

18.5.5

18.4.2

18.5.1_Trial

18.5.4

18.5.2

1805_CERT_PUT14

Adhoc_PUT14_Mano

Adhoc_03_WPIL_TSTS

Adhoc_PNR_FOP_TSTS

Adhoc_Sprint11_Newscripts

DAILY_OLL_CERTC_0507

DAILY_OLL_CERTC_0506

Adhoc_CMT24012

Adhoc_ACPMXA_QDC_18MAY

Adhoc_CMT23507_SchedChange

Adhoc_ACPMXA_QDC_15MAY

Adhoc_ACPMXA_QDC_22MAY

Adhoc_ACPMXA_QDC_23MAY

Adhoc_ACPMXA_QDC_22MAYGDS

DAILY_OLL_CERTD_0603

DAILY_OLL_TSTSB_0508

DAILY_OLL_TSTSB_0515

DAILY_OLL_TSTSB_0506

DAILY_OLL_TSTSB_0509

DAILY_OLL_TSTSB_0514

DAILY_OLL_TSTSB_0510

DAILY_OLL_TSTSA_0527

DAILY_OLL_TSTSB_0503

DAILY_OLL_TSTSA_0530

DAILY_OLL_TSTSA_0607

DAILY_OLL_TSTSA_0529

DAILY_OLL_TSTSA_0531

DAILY_OLL_TSTSA_0606

DAILY_OLL_TSTSA_0603

DAILY_OLL_TSTSA_0604

DAILY_OLL_TSTSB_0513

LATAM_18.5_FALLBACKSEG_CERT

DAILY_OLL_TSTSB_0520

LATAM_18.5_FALLBACKSEG

LATAM_Refactoring

18.4.3

std_acs

std_airlines

LATAM_18.5_Adhoc

DAILY_OLL_TSTSB_0528

DAILY_OLL_TSTSB_0605

DAILY_OLL_TSTSB_0522

DAILY_OLL_TSTSB_0530

DAILY_OLL_TSTSB_0603

DAILY_OLL_TSTSB_0531

DAILY_OLL_PKGE_0607

DAILY_OLL_PKGE_0528

DAILY_OLL_PKGE_0604

DAILY_OLL_PKGE_0527

DAILY_OLL_PKGE_0529

DAILY_OLL_PKGE_0603

DAILY_OLL_PKGE_0530

DAILY_OLL_PKGE_0531

DAILY_OLL_TSTSA_0523

DAILY_OLL_PKGE_0517

DAILY_OLL_PKGE_0523

DAILY_OLL_PKGE_0516

DAILY_OLL_PKGE_0520

DAILY_OLL_PKGE_0522

DAILY_OLL_PKGE_0521

DAILY_OLL_PKGE_0524

DAILY_OLL_TSTSA_0513

DAILY_OLL_PKGE_0605

DAILY_OLL_TSTSA_0510

DAILY_OLL_TSTSA_0514

DAILY_OLL_TSTSA_0520

DAILY_OLL_TSTSA_0515

DAILY_OLL_TSTSA_0516

DAILY_OLL_TSTSA_0509

DAILY_OLL_PKGE_0515

DAILY_OLL_TSTSA_0508

DAILY_OLL_PKGE_0606

DAILY_OLL_TSTSA_0502

DAILY_OLL_TSTSA_0506

DAILY_OLL_TSTSA_0503

];