topic Re: hide empty line in QlikView

hide empty line

Mon, 17 Aug 2015 09:19:47 GMT

hello,

I have a document witch shows article info, the field ftplink shows a link to a document, in some cases the are 2 rows for an article.

the empty row dont needed te be loaded.

I already tried the where statement however it is not the same value. can i use somthing like ftp://*

Ralf-Narfeldt — Mon, 17 Aug 2015 12:09:22 GMT

Do you want to discard all lines where ftplink contains ftp:// ?

In that case

Load

....

Where SubStringCount(ftplink, 'ftp:') = 0;

Mon, 17 Aug 2015 12:16:58 GMT

I want to hide all empty rows en and show all rows witch contain 'ftp://*'

Ralf-Narfeldt — Mon, 17 Aug 2015 13:02:52 GMT

Then it's:

Load

....

Where SubStringCount(ftplink, 'ftp:') > 0;

Mon, 17 Aug 2015 13:29:46 GMT

getting an error

sasiparupudi1 — Tue, 18 Aug 2015 11:44:42 GMT

try like this

temp:

sql select

Nummer,

Tekst

from "PRODUCTIE DATA".Vertaal;

final:

load

Nummer,

Tekst

resident temp

where wildmatch(ftplink, 'ftp://*')>0;

drop table temp;

Ralf-Narfeldt — Tue, 18 Aug 2015 12:17:15 GMT

Yes, you can't use the SubstringCount function in the SQL Select, it needs to be done in a preceding Load, or a Resident load like Sasidhar showed.

But you wrote that there was a field called ftplink, and in your example you load fields Nummer and Tekst, so Sasidhar's example won't work either.

In which field is the ftp address?

qlikviewwizard — Tue, 18 Aug 2015 13:24:56 GMT

Can you please attach the sample file to fix the issue quickly? Thank you.