How to join two crosstab tables?

[nehasaxena]

Hi Experts,

I have created 3 crosstab tables in my app. Now i want to join these tables but when  i am trying this with concatenate function but its not working...

Pls help me

Thanks in Advance!!

[#2]

First of all, we can't join or concatenate the two or more cross tables in qlikview. Its illegal syntax.

So first you need to create the TEMP tables with Cross Table after that concatenate all the temp tables by using resident tables. If the temp tables have more no of rows then create TEMP qvd's and then concatenate all the TEMP qvd's.

[nehasaxena]

Hi kumar raman,

Thanks a lot!! Its working fine.