Sorting Issue in Pivot table

[#1]

Hello Friends,

I have a column name Delivery it contains value of > 5, 1J, 2J, 3J, 4J, 5J, NA. I would like to display like in the Order of 1J, 2J, 3J, 4J, 5J, >5.

Anybody can help me.

Regards

Ammu

[Anonymous]

HI!

Search the QlikView Help for the "dual"-function.

If you apply the dual-function to your field during the script-load, you can sort the field in numeric order on the frontend.

load dual ( string,numrep ) as DayOfWeek inline

[ string,numrep

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

load Date, weekday(Date) as DayOfWeek from afile.csv;

[#3]

Hi,

Thanks for your reply, I tried to do but not able to achieve it, could you please share any example.

Regards

Ammu

[Anonymous · Accepted solution]

HI!

Take a look at the attached .qvw!

Field "DimDual" can be sorted numeric!

[#5]

Hi,

Fantastic, now its working fine....

Thanks for your help

Regards

Ammu