Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables.
table 1
Record ID
1 A
2 B
3 C
4 D
Table 2:
Field1 IDRelacion
1 AAA
1 BBB
1 CCC
1 DDD
2 EEA
I turn them as follows:
ID & chr (10) & Registration & chr (10) & concat (field1, chr (10)
1
A
AAA
BBB
CCC
DDD
But I nesecito that those letters are in order so descendeten:
EEA
Hi.
Have you tried the solution ?
http://community.qlik.com/message/262039#262039Re: Ordenar valores Concatenados?