Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

naming columns

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

23 Replies
tresesco
MVP
MVP

Could you post a sample excel?

arjunkrishnan
Partner - Creator II
Partner - Creator II

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

VishalWaghole
Specialist II
Specialist II

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
Partner - Creator II
Partner - Creator II

Hi

Not applicable
Author

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
Partner - Creator II
Partner - Creator II

Hi

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 ...

Not applicable
Author

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.

Not applicable
Author

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