Discussion Board for collaboration related to Creating Analytics for QlikView.
i attached a qv-file that shows my problem.
i have two tables and i want to connect them over the dimensions D2 and A2. The problem is that Dimension A2 contains not only charactes - numbers and signs too.
Is there any function to cut the signs and numbers of dimension a2 so that i can join the both tables?
Go to Solution.
Done. Please check attached app.
you can try:
KeepChar( A2 ,'abcdefghijklmnopqrstuvwxyz')
in your loading script
I didn't know it can be two dimension as an argunemt of keepchar
Thank you very much qlikuser14!
'But know i have different values in Dimension D2 and A2.
With your solution it is now not possible. how can i get the right table, that show in the first line the values of
D1 = 2 and A1 = 1,
D1^= 65, and A1 = 89,
D1 = 77 and A2 = 79.