Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Phara
Contributor III
Contributor III

How to add a blank dimension in a sheet

Hello,

I'd like to add a blank dimension, which mean nothing has to show in that column. What will be the expression for this, or is there any way that I can do this?

The purpose of this is to facilitate the copy of the data in an Excel sheet that has an extra column compare to the original extract in Qlik.

Thanks everyone!

Labels (2)
1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

Something like this?

Levi_Turner_0-1715279035229.png

I used =Chr(160) for my dimension.

 

View solution in original post

3 Replies
Vaibhav_Pathak
Contributor II
Contributor II

Hi Phara,

You can add blank dimension by creating an IF condition in your load script editor. Take any column and write if condition like if that column value is null or not null than enter null in new column with name you want to create.

Attaching a image of my load script editor for your reference.

Vaibhav_Pathak_0-1715278483851.png

 

Levi_Turner
Employee
Employee

Something like this?

Levi_Turner_0-1715279035229.png

I used =Chr(160) for my dimension.

 

Phara
Contributor III
Contributor III
Author

Yes, thank you so much @Levi_Turner !!