Cross Table and Join Table???

[#1]

Dear Experts,

Can you please explain about the cross/join tables.

When we want to use them and what is the usage of them??

Example please.....!!

Rgds,

Priyantha.

[Gysbert_Wassenaar · Accepted solution]

See these blog posts:

The Crosstable Load

Understanding Join, Keep and Concatenate

[#3]

The Crosstable Load

Different Join Functions in Qlikview

Please go thorugh the link for detail understanding.

[buzzy996]

by using cross table,any point of time

1. we can move objects rows as columns and wise versa.

2. we see partial sums

3. drill up/down groups.

[avinashelite]

Hi,

crosstable load is used when the column data needs to be converted as row data ,

eg:

A,B,C

1,2,3

4,5,6

to convert like

Measure,value

A,1

A,4

B,2

B,5

C,3

C,6

Join's are used when  you need to combine to different table as single table , it's completely dependent on the your requirement .

eg,

A,B

1,2

and table 2

A,C

1,3

if you perform join(outer join ) on this

A,B,C

1,2,3

hope this helps you

[Anonymous]

Hi Avinash,

thanks for the post.

how would I use a cross table to load this please:-

under each month is the targets that I need to load per team_id and the consultant id(i.e. the second column)

thanks in advance