Cross table

[#1]

HI ,

My question is i have a excel sheet which has many columns like : current states, product. websites,base Hp,base IBM,base CMS,

base Epson , Version. sentiments, grades  and performance .

I want to know that using cross table how can i make a column by name BASE and include all the (base HP,IBM,CMS,Epson)

Can anyone plz help me out

[MK_QSL]

Can you load your sample file.

May be Generic Load can help you.

Try to find our the same in QlikView Community...

[#3]

hi

the way i have written above is the orderwise of my excel sheet columns  , when i do cross table i have some thing like attribute , qualifiers, and data . but the thing is i want  all the base(hp.IBM,CMS,Epson) to come under one column BASE  , i dont know how to do that

[sujeetsingh]

See this sample it will help you to have a concept of cross table clear.

[#5]

hi sujeeth

Thanks for ur concern  but my question is something different , as a i have posted above 

like

My question is i have a excel sheet which has many columns like : current states, product. websites,base Hp,base IBM,base CMS,

base Epson , Version. sentiments, grades  and performance .

I want to know that using cross table how can i make a column by name BASE and include all the (base HP,IBM,CMS,Epson)

[jonathandienst · Accepted solution]

Hi

Using crosstable:

T_Data:

Crosstable (Name, Value, 7)

LOAD

[current states], product, websites, Version, sentiments, grades, performance, [base Hp], [base IBM], [base CMS], [base Epson]

FROM ......

Data:

NoConcatenate

LOAD [current states],

  product,

  websites,

  Version,

  sentiments,

  grades,

  performance,

  SubField(Name, ' ', 2) As Name,

  Value

Resident T_Data;

DROP Table T_Data;

The field list in your post was a little ambiguous, so you might need to fix the field names and change the value 7 to however many attribute fields are before the base* fields. And note that the crosstabled fields must after all the attribute fields (so the base* fields must the last ones in the LOAD statement).

HTH

Jonathan

[#7]

Thanks for ur support  Jonathan , i am really stuck with my assignment , i have been given with a excel sheet along with ppt  there are some fields in ppt which are not present in the ecel if u dont mind can u please give me ur email id so that i can send u the file ?

[jonathandienst]

Please post it here in the community. (in a new post).