Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadcm
Contributor II

Insert multiple null values in straight table Dimension

how to add multiple blank space in butterfly table dimension ..

its giving me only 1 blank value for all other blank values

1 Solution

Accepted Solutions
Not applicable

Re: Insert multiple null values in straight table Dimension

you can use '  ' , '   ' so that it will consider as different values

and in Properties  sorting tab select LOAD ORDER check box

9 Replies
MVP
MVP

Re: Insert multiple null values in straight table Dimension

qvw you have attached is completely blank.

Not applicable

Re: Insert multiple null values in straight table Dimension

can you pls upload qvw again

prasadcm
Contributor II

Re: Insert multiple null values in straight table Dimension

updated QVW

skusuma1991
Contributor

Re: Insert multiple null values in straight table Dimension

Hi prasad,

Use null() in inline while loading the script

Regards

Sagar

MVP
MVP

Re: Insert multiple null values in straight table Dimension

Where do you want to add a null value in here??

Not applicable

Re: Insert multiple null values in straight table Dimension

you can use '  ' , '   ' so that it will consider as different values

and in Properties  sorting tab select LOAD ORDER check box

skusuma1991
Contributor

Re: Insert multiple null values in straight table Dimension

Hi Prerana,

But i am finding 1 in billing and booking column how to remove that from the table ...

Regards,         

Sagar

Not applicable

Re: Insert multiple null values in straight table Dimension

instead of 1 you can write your expression 

Not applicable

Re: Insert multiple null values in straight table Dimension

Hi Sagar,

you can use 'nested if condition' in the expression.

Please fine the attached QVW.