Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustTryingToLearn
Contributor III
Contributor III

Adding a column to each sheet with the name of the sheet

Hi,

I am trying to build a dashboard in Qlik Sense. My data comes from many different sheets that are similar to each other. I want to bring the data in an concatenate it, but I also want to know what sheet the data come from. I think the best way to do this is by adding a field to each sheet as I bring it in, and then populate that with the name of the sheet for every row. Only problem is, I don't know how to do this. 

Can someone help me with this? Is there a better way to do this? 

Labels (3)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

You can create a variable that contains the name of the sheet like this:

let vSheetName = 'Sheet1';

Load
    Field1,
    Field2,
    '$(vSheetName)' as _indSection
From [YourSource]
;

 

We often use _indSection to name the column that separates sections in your table.

Jordy

Climber

Work smarter, not harder