How to add a blank dimension in a sheet

[Phara]

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!

[Vaibhav_Pathak]

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.

[Levi_Turner · Accepted solution]

Something like this?

I used =Chr(160) for my dimension.

[Phara]

Yes, thank you so much @Levi_Turner !!