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: 
Not applicable

Remove empty lines from table

Hi all,

Perhaps a simple question, but I'm having trouble figuring it out. I need to remove the Null values from a table (see attachment), but the first row should always be displayed! So 'don't show if value is empty' does not work here, since it will also not show the first row?

Thanks,

Stijn

16 Replies
sunilkumarqv
Specialist II
Specialist II

on Properties - Expressions Tab -

see Null Symbol u can remove symbol -  

senpradip007
Specialist III
Specialist III

In Dimensions tab check Suppress When Value is Null.

Not applicable
Author

If you want to hide the record of Null values then you should check the option Suppress Null Values under Dimension tab and presentation tab.

or If you want to show the Values for the Null then you can replace Null symbol by N/A under Presentation tab.

Not applicable
Author

When I do that, surpressing null value for column Prev wo_date, the first row of the table is also removed. And that row should always be shown. So I only need to remove the null values from every row EXCEPT the first one?

Anonymous
Not applicable
Author

Post the data or the sample qvw and I will provide you a solution......

senpradip007
Specialist III
Specialist III

Can you upload sample app?

Not applicable
Author

I've posted the qwv file

Anonymous
Not applicable
Author

Is there a chance to identify the first row which you want to display?

then you could change the expression to something like

if (firstrow= true and wo_date is null, 'define something', wo_date)

If it is the first row, the table will have a value and not null and displays it

the other remainin g rows with null won't be displayed

ashfaq_haseeb
Champion III
Champion III

Hi,

Why you need first row?

Its just simple repetition, you can omit that

Regards

ASHFAQ