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: 
prasadcm
Creator II
Creator 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

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

and in Properties  sorting tab select LOAD ORDER check box

View solution in original post

9 Replies
sunny_talwar

qvw you have attached is completely blank.

Not applicable

can you pls upload qvw again

prasadcm
Creator II
Creator II
Author

updated QVW

Anonymous
Not applicable

Hi prasad,

Use null() in inline while loading the script

Regards

Sagar

sunny_talwar

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

Not applicable

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

and in Properties  sorting tab select LOAD ORDER check box

Anonymous
Not applicable

Hi Prerana,

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

Regards,         

Sagar

Not applicable

instead of 1 you can write your expression 

Not applicable

Hi Sagar,

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

Please fine the attached QVW.