topic Re: Sorting Issue in Pivot table in QlikView

Sorting Issue in Pivot table

Fri, 11 Jan 2013 08:00:54 GMT

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 — Fri, 11 Jan 2013 08:38:16 GMT

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;

Fri, 11 Jan 2013 09:34:09 GMT

Hi,

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

Regards

Ammu

Anonymous — Fri, 11 Jan 2013 11:40:58 GMT

HI!

Take a look at the attached .qvw!

Field "DimDual" can be sorted numeric!

Fri, 11 Jan 2013 11:57:29 GMT

Hi,

Fantastic, now its working fine....

Thanks for your help

Regards

Ammu