topic Re: How to exclude empty records from a table to historize? in QlikView

How to exclude empty records from a table to historize?

datanibbler — Mon, 04 May 2015 09:32:36 GMT

Hi,

I have a table that should have 16 records to historize on a daily basis - but it has 17.

=> That is because I have used a FIRST 1 LOAD to generate a dummy_table which I could concatenate to in every iteration of a loop.

Now I am trying to get rid of this again.

In some fields, there is nothing even in those records which I want to keep, but there are other fields where there is always a value.

So I tried with LEN() and ISTEXT() already, but those don't work for whatever reason.

Is there another way to do this more reliably?

Thanks a lot!

Best regards,

DataNibbler

Re: How to exclude empty records from a table to historize?

sujeetsingh — Mon, 04 May 2015 09:43:48 GMT

For the field which you have no value use

Load *

from where len(Field)<>0;

Re: How to exclude empty records from a table to historize?

Peter_Cammaert — Mon, 04 May 2015 09:53:30 GMT

Alternately, use a LOAD prefix in a variable. For example, this one does away with the FIRST 1 LOAD... (I know you don't like the wiggly lines at all, sorry about that )

LET vLoadPrefix = '[Table H]: NOCONCATENATE';

FOR x = 1 TO 16

$(vLoadPrefix)

LOAD whatever FROM wherever;

LET vLoadPrefix = 'CONCATENATE ([Table H])';

Best,

Peter

Re: How to exclude empty records from a table to historize?

datanibbler — Mon, 04 May 2015 09:59:26 GMT

Hi Peter,

no worries.

But in the meantime I have found a way of my own.

I just find out the nr. of rows in that table and then use a FIRST ... statement to load one less ( I have sorted it before, so I know that the empty record is the last one).

Thanks a lot anyway!

P.S.: I still have no clue why I cannot mark any answers as "helpful" anymore, I just have one button "correct" and logically I can use that only once ...

Re: How to exclude empty records from a table to historize?

Peter_Cammaert — Mon, 04 May 2015 10:12:04 GMT

Ah, maybe this is why I don't seem to get any Helpful's anymore. Look under Actions (is it Aufgaben in German? Dunno) in the bottom left corner of every post. It should be there...

BTW IMHO this is indeed a rather bad design decision from Jive. Or are we getting too much points too quickly?

Re: How to exclude empty records from a table to historize?

datanibbler — Mon, 04 May 2015 10:16:18 GMT

Hi,

No, that one is "Aktionen" in German. Pretty similar. I don't know who changed this and why, but there used to be a rather obvious button ... I know it is still around somewhere though because I get lots of emails when someone marked someone's reply as "helpful" which I don't really care about 😉

P.S.: You are right. It is under "Actions". Not quite obvious ...

If employers were to look at the points in this community whenever someone looks for a job in this area ... but that is not the case. I am currently not so sure about my job here - it is okay, but not ideal. So I'm looking for a way (other than the official certifications which I'm unlikely to get) to "prove" my experience with QlikView. Unfortunately in Germany, official papers are worth a lot and without them it is harder ...