topic Re: Order Table in QlikView

Order Table

Tue, 17 Jan 2017 16:46:26 GMT

Hello everyone! i have an issue to create one table like that :

Field 1	Field 2
A	B
B	C
C	D
D

I want to create a table, like the forward example, in the Script Editor.

From field A, I want to create a field B equal to that shown in the figure. In field A I have the order "A - B - C - D" and I want to create a field B associated to field A with the Association "B - C - D" where A = B and B = C and C = D.

Help me please.

Re: Order Table

eespiritu — Tue, 17 Jan 2017 17:24:00 GMT

Hi,

Try to use this code:

TMP_TABLE:

LOAD * INLINE [

ID,FIELD1

1, A

2, B

3, C

4, D

];

NoConcatenate

Final:

Load

ID,

FIELD1,

Peek('FIELD1') as FIELD2

Resident TMP_TABLE

order by ID desc;

Drop table TMP_TABLE;

Regards,

Enrique

Re: Order Table

Wed, 18 Jan 2017 19:16:08 GMT

Yhank you ! it work with numbers, but dont work with dates... do you know why ?! thanks

Re: Order Table

eespiritu — Wed, 18 Jan 2017 19:51:01 GMT

No problem.

Do you have the example?, what are you trying to do with the dates?

Re: Order Table

Wed, 18 Jan 2017 21:09:55 GMT

the same think! but when i put dates in the field, the dates dont show... probably is an formating issue...

Re: Order Table

Anonymous — Wed, 18 Jan 2017 21:14:30 GMT

Try formatting your dates as numbers in your script num(DateField)