Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
6 | 70 | 17 |
12 | 75 | 40 |
6 | 100 | 43 |
6 | 70 | 17 |
12 | 75 | 40 |
6 | 100 | 43 |
6/70/17 |
12/75/40 |
6/100/43 |
Joining the data from the 3 fields seperating them bij a / and showing them in 1 field.
Is this possible, and if so how?
Tom
Hi, Tom
Have you tried to concatenate your 3 columns in the script loading as shown below?
Hope this helps
ZZ
Hi, Tom
Have you tried to concatenate your 3 columns in the script loading as shown below?
Hope this helps
ZZ
Are you going to use in front end which is expected field? If so, What purpose you used?
Hi ZZ,
Your suggestion worked.
But now I have another problem.
I would like for Qlikview to display only the "newfield".
However I use the fileds a b c to sort the data.
If I do not include fields a b c in the table object Qlikview displays "newfield" in the wrong order.
Is there a solution for this?
T.
Hi, Tom
Probably you can try sort the new field by using the rank expression as below
rank(a)*100+rank(b)*10+rank(c)
and the result should be something similar as below
Hope this helps
ZZ