topic Re: Create a simple table like a pivot table in QlikView

Create a simple table like a pivot table

Thu, 14 Feb 2013 09:59:06 GMT

Don't know how to do this ?

Thanks

swuehl — Thu, 14 Feb 2013 10:48:13 GMT

You should create a numeric order number field in your script:

LOAD

Order,

keepchar(Order,'0123456789') as OrderNum,

...

Then you can use e.g. for 1. orders:

=FirstSortedValue(Order,OrderNum,1)

and second orders:

=FirstSortedValue(Order,OrderNum,2)

Thu, 14 Feb 2013 10:55:20 GMT

Thank you very mutch. This is exactly that i want