topic Re: Cross table in QlikView

Cross table

Mon, 24 Feb 2014 09:24:50 GMT

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

Re: Cross table

MK_QSL — Mon, 24 Feb 2014 09:33:23 GMT

Can you load your sample file.

May be Generic Load can help you.

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

Re: Cross table

Mon, 24 Feb 2014 09:42:54 GMT

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

Re: Cross table

sujeetsingh — Mon, 24 Feb 2014 09:43:26 GMT

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

Re: Cross table

Mon, 24 Feb 2014 10:01:01 GMT

hi sujeeth

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

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)

Re: Cross table

jonathandienst — Mon, 24 Feb 2014 10:02:13 GMT

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

Re: Cross table

Mon, 24 Feb 2014 10:09:03 GMT

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 ?

Re: Cross table

jonathandienst — Mon, 24 Feb 2014 12:06:04 GMT

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