Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Well, if you are using personal edition qv, here is the script I used :
CrossTable(Tech, Data, 😎
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
[<Yourpath>\Create a dash board.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hi Tressco 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
Hi,
Try this
Test123:
CrossTable(Topic,TopicValue,1)
LOAD [Topic Content ID],
[Topic: Calvin Klein],
[Topic: Diesel],
[Topic: Killer Jeans],
[Topic: Lee Cooper Jeans],
[Topic: Lee Jeans],
[Topic: Levis],
[Topic: Pepe Jeans London],
[Topic: Spykar],
[Topic: Wrangler Jeans]
FROM
(
Res:
NoConcatenate
Load [Topic Content ID],
SubField(Topic,':',2) as Topic
Resident Test123;
Drop Table Test123;
hi Ravi no its not working , After loading the script as u suggested its showing an error like could not find fil
Hi Wrestler,
Please find attached file, it will help you.
I have wrote script for that as..
CrossTable(Name, Data, 7)
LOAD * FROM
(ooxml, embedded labels, table is Sheet1);
- Regards,
Vishal Waghole
Hi Wrstler,
Pls Reffer This Helpful For U....
If U Can't Able To Open this File Means,
Script Code:
Table:
CrossTable(Topic, Values)
LOAD [Topic Content ID],
[Topic: Calvin Klein],
[Topic: Diesel],
[Topic: Killer Jeans],
[Topic: Lee Cooper Jeans],
[Topic: Lee Jeans],
[Topic: Levis],
[Topic: Pepe Jeans London],
[Topic: Spykar],
[Topic: Wrangler Jeans]
FROM
[1223.xlsx]
(ooxml, embedded labels, table is Topic);
Table2:
LOAD *,
subfield(Topic,':',2) as JEANS_Name
Resident Table;
DROP Table Table;
Hi vishal the file u attached is not opening , when i double clik on it the error messeg is like u cannot open it becuase the file is open too many times , can u paste the script on community itself
Load like this
A:
CrossTable(Topic,TopicValue,1)
LOAD [Topic Content ID],
[Topic: Calvin Klein],
[Topic: Diesel],
[Topic: Killer Jeans],
[Topic: Lee Cooper Jeans],
[Topic: Lee Jeans],
[Topic: Levis],
[Topic: Pepe Jeans London],
[Topic: Spykar],
[Topic: Wrangler Jeans]
FROM
(ooxml, embedded labels, table is Topic);
B:
NoConcatenate
Load [Topic Content ID],
SubField(Topic,':',2) as TopicName
Resident A;
Drop Table A;
And when using this script change your source location like in this line
Hope this helps
Please post the exact script what you are using
I think you are using the same script of myne without modifying the file path
This is myne
FROM
(
You should use your file path insteadof my path
Hi,
please find script code that i have created.
CrossTable(Name, Data, 7)
LOAD * FROM
[Create a dash board.xlsx] // make sure that, this location is your file stored folder location
(ooxml, embedded labels, table is Sheet1);
- Regards,
Vishal Waghole