Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
chunlung1
Contributor II
Contributor II

Remove worksheet name in Field

Hello! I am new to QlikSence. I receive an excel with muti-worksheet (sheet1-3) but same format like below

  Jan22 Feb22 Mar22 Apr22 May22 Jun22 Jul22 Aug22 Sep22 Oct22
A 1 1 1 1 1 1 1 1 1 1
B 2 2 2 2 2 2 2 2 2 2
C 3 3 3 3 3 3 3 3 3 3

 

Since there are three sheet with same header (e.g Jan22), when i tried to create a table, the header become sheet1.Jan22

 

I would like to just display Mar22 but not sheet1.Mar22 in the table, is there any ways to do it without manually  changing the label? Thank you!!

chunlung1_1-1684375314095.png

 

 

Labels (2)
1 Solution

Accepted Solutions
PrashantSangle

can you provide little bit more information.

How you are loading data? using data load editor or data manager?

Can you share your script?

 

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
PrashantSangle

can you provide little bit more information.

How you are loading data? using data load editor or data manager?

Can you share your script?

 

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
chunlung1
Contributor II
Contributor II
Author

currently I am using data manager to import the excel, but i am also trying to create new connection to oneDrive, thanks!

PrashantSangle

cool. you are getting this error only because of data manager. Once load data from Script. you will get correct names of it.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
chunlung1
Contributor II
Contributor II
Author

Now that I am using load data from Script, the names is corrected, but I face another issue which the data I load is combining all value in different worksheet together!

For example, when I try to create a table, it shown more then three row (4-9 should belongs to different table in other worksheet). Is there any ways to separate the row? e.g. 4-6 should belongs to table in worksheet 2 and 7-9 should belongs to table in worksheet 3. Thank you!

Task Mar22 Apr22 May22 Jun22 Jul22 Aug22 Sep22
A 1 1 1 1 1 1 1
B 2 2 2 2 2 2 2
C 3 3 3 3 3 3 3
- 4 4 4 4 4 4 4
- 5 5 5 5 5 5 5
- 6 6 6 6 6 6 6
- 7 7 7 7 7 7 7
- 8 8 8 8 8 8 8
- 9 9 9 9 9 9 9