topic Re: Cross Table in QlikView

Cross Table

Thu, 08 Sep 2011 05:31:40 GMT

What is cross table? How it's created? Why we need this??

Anybody please help me!!!!!

Cross Table

its_anandrjs — Thu, 08 Sep 2011 07:01:59 GMT

Hi,

Cross table is a table from which you make any number of rows comes under single column

ColA,ColB,ColC,ColD

and you want to cross ColC,ColD then it comes under single column

and rest are ColA,ColB individuals

like in code

CrossTable(orgname, Data, 2)

LOAD ColA,

ColB,

ColC,

ColD

FROM

Data

In Data ColC,ColD are comes

and in orgname ColA,ColB

Regards,

Anand

Cross Table

SunilChauhan — Thu, 08 Sep 2011 09:23:21 GMT

crosss usse in case you have to combine multiple columns into 2 column

i.e all column name in one column and valuee in anotheer column

see the example below

EmpId,Ename,jan'10,feb'10,mar'10,apr'10
1,sk,100,200,300,400
2,Vk,500,600,700,800
3,tk,1500,1600,1700,1800

then
using cross table we can have 4 columns
EmpId,Ename,Month,Value

where month contains jan'10,feb'10,mar'10,apr'10
and value contains 100,200,300,400,500,600,700,800,1500,1600,1700,1800

Re: Cross Table

its_anandrjs — Thu, 08 Sep 2011 09:28:49 GMT

Hi,

See the attached sample file for clearity.

Regards,

Anand

Re: Cross Table

SunilChauhan — Thu, 08 Sep 2011 10:12:31 GMT

take a new qvw and

take excel file atached

Control+E-> tabl files->next->next ->Cross table->

down no of qulified field give thee no (in example attached 1)

give the name of attribute and vales

finish ok

and drag all filed into tablebox

this is all about cross tablee

we need to use cross table for budget files for ex.

Cross Table

Thu, 08 Sep 2011 10:18:18 GMT

Thanks Sunil & Anandrjs..............................

Re: Cross Table

its_anandrjs — Thu, 08 Sep 2011 10:32:31 GMT

Hi,

See the another demo of the file Cross table here it is showing Question and its information

Table:

CrossTable(Que, Data, 2)

LOAD

ColA,

ColB,

De01,

De03,

De05,

De07,

De09

FROM

CrossData.xlsx

(ooxml, embedded labels, table is Sheet1);

2 means form column 2 the table will get crossed it will depends on you from which column you want a cross table so just increase or decrease it from there.

Regards,

Anand

Cross Table

SunilChauhan — Thu, 08 Sep 2011 16:47:53 GMT

anup what is difference beetween my attachment and anand's attachment

Cross Table

Fri, 09 Sep 2011 04:27:35 GMT

Both are same sunil.