topic Re: Remove empty lines from table in QlikView

Remove empty lines from table

Mon, 25 Aug 2014 09:24:30 GMT

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

Re: Remove empty lines from table

sunilkumarqv — Mon, 25 Aug 2014 09:26:28 GMT

on Properties - Expressions Tab -

see Null Symbol u can remove symbol -

Re: Remove empty lines from table

senpradip007 — Mon, 25 Aug 2014 09:28:52 GMT

In Dimensions tab check Suppress When Value is Null.

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:30:47 GMT

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.

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:32:43 GMT

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?

Re: Remove empty lines from table

Anonymous — Mon, 25 Aug 2014 09:36:08 GMT

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

Re: Remove empty lines from table

senpradip007 — Mon, 25 Aug 2014 09:38:21 GMT

Can you upload sample app?

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:40:24 GMT

I've posted the qwv file

Re: Remove empty lines from table

Anonymous — Mon, 25 Aug 2014 09:40:27 GMT

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

Re: Remove empty lines from table

ashfaq_haseeb — Mon, 25 Aug 2014 09:43:02 GMT

Hi,

Why you need first row?

Its just simple repetition, you can omit that

Regards

ASHFAQ

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:44:30 GMT

Well the first row always has the lowest km_val value (for that certain MRCE number). Perhaps this can be used?

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:47:28 GMT

Perhaps it is easier to delete the duplicate km_val in table2? see attachment

Re: Remove empty lines from table

Mon, 25 Aug 2014 09:48:31 GMT

I need the first row because it shows the beginning km_val for that MRCE value. And it has no previous date, so the first row should display -, while the other rows should only show the date and not a -

Re: Remove empty lines from table

Mon, 25 Aug 2014 10:27:20 GMT

Is anyone having an(other) idea?

Re: Remove empty lines from table

CELAMBARASAN — Mon, 25 Aug 2014 10:36:24 GMT

You could try something like this

If(RowNo()=1, [MRCE Nr.], Only({<[Prev wo_date]={'*'}>}[MRCE Nr.]))

or this one

Only({<wo_date={'$(=Min(wo_date))'}>+<[Prev wo_date]={'*'}>}[MRCE Nr.])

Re: Re: Remove empty lines from table

senpradip007 — Mon, 25 Aug 2014 10:39:53 GMT

PFA

Re: Remove empty lines from table

Anonymous — Mon, 25 Aug 2014 10:43:32 GMT

Try this:

load the data from the excel sheet

load with noconcatenate from resident with rowno()

and order by km_val

load

rowno(),

if (rowno()=1, km_val) as StartKMVAL

...

resident PrevTable

order by km_val

Then you should be able to define

if (StartKMVA), "Start KM", wo_date)

and the first row should be displayed