Discussion Board for collaboration on QlikView Scripting.
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?
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.
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?
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