naming columns

[#1]

Hi i have a excel sheet of which i have to put a dashboard , In my excel sheet i have columns names as

Tech:rahul,  Tech:padma, Tech:manoj,Tech:asha ,Tech:vinod

my question is i want to bring all the name under one column as Tech ,.

How do i do that

[tresesco]

Could you post a sample excel?

[arjunkrishnan]

Use Cross Table Is Possible One ..Ur Field Become One Column Value... Or ...Use Condition

[VishalWaghole]

Hi wrestler,

You can use cross table option for this type of scenario.

but if possible then please post your dummy data.

- Regards,

Vishal Waghole

[its_anandrjs]

Load data one by one see the code below

Load

Tech:rahul as Tech

From location;

Load

Tech:padma as Tech

From location;

Load

Tech:manoj as Tech

From location;

Load

Tech:asha as Tech

From location;

Load

Tech:vinod as Tech

From location

If columns are same qlikview load single table with multiple table.

Thanks & Regards

[arjunkrishnan]

Hi wrestler.,

See This Qvw ...It's helpfull For U ....

[#7]

Try this

Test123:

CrossTable(TechName,TechValue,8)

LOAD [Sentiment Score],
Sentiment,
Date,
[Source Name],
Author,
Location,
[Fb Likes/Youtube view],
[Topic: Calvin Klein],
Tech:vinod,
Tech:asha,
Tech:rahul,
Tech:raj,
Tech:neetha,
Tech:seema
FROM

(ooxml, embedded labels, table is Sheet1);

Res:
NoConcatenate
Load [Sentiment Score],
Sentiment,
Date,
[Source Name],
Author,
Location,
[Fb Likes/Youtube view],
[Topic: Calvin Klein],
subfield(TechName,':',2) as TechName,
TechValue

Resident Test123;

Drop Table Test123;

[arjunkrishnan]

Hi wrestler.,

CrossTable(TECH, VALUES, 😎

LOAD [Sentiment Score],

    Sentiment,

    Date,

    [Source Name],

    Author,

    Location,

    [Fb Likes/Youtube view],

    [Topic: Calvin Klein],

    Tech:vinod as vinod,

    Tech:asha as asha,

    Tech:rahul as rahul,

    Tech:raj as raj,

    Tech:neetha as neetha,

    Tech:seema as seema

FROM

[Create a dash board(1).xlsx]

(ooxml, embedded labels, table is Sheet1);

Show Below Image Wht will Happening On Here ...

[#9]

Hi Wrstler,

CrossTable(Tech, Data, 7)

LOAD [Sentiment Score],

     Sentiment,

     Date,

     [Source Name],

     Author,

     Location,

     [Fb Likes/Youtube view],

     [Topic: Calvin Klein],

     Tech:vinod,

     Tech:asha,

     Tech:rahul,

     Tech:raj,

     Tech:neetha,

     Tech:seema

FROM

(ooxml, embedded labels, table is Sheet1);

try this one it will work.

[#10]

Hi Kiran thanks for the reply but i tried all the things its giving the error , Iam new to qlik view

i have a excel sheet which i will be forwarding to u , In that excel sheet there are many fields , and my task is to build the dashboard

. I wanted to know how to rename the fields topic: jeans, topc: lee, topc:spykar and so on  ,as TOPIC and include all the jeans under topic

plz find the attachement