topic Re: remove rows in QlikView

remove rows

Anonymous — Wed, 19 Mar 2014 20:36:29 GMT

Hi,

I loaded query from SQL, where I got many rows for each respondentID.

Then I want to remove rows, which has Adoption.

I tried to load from resident table with condition where Dimension<>'Adoption'. Didn't work.

How to remove them?

Regards,

Re: remove rows

veidlburkhard — Wed, 19 Mar 2014 20:44:08 GMT

Hi Vladimir,

can you give a screen shot of your script where you tried this load?

Then I will have a look...

Regards

Burkhard

Re: remove rows

Wed, 19 Mar 2014 20:49:06 GMT

Field names and values are case sensitive so make sure they match and also check the spelling
Do a preload like below

Load

Where Dimension <> 'Adoption' ;

SQL Select *

From DataBase;

Re: remove rows

stevedark — Wed, 19 Mar 2014 23:50:07 GMT

Hi Ajay,

In your code would this not bring all the rows across from SQL regardless of the Dimension, and then subsequently drop them out of memory. This be a waste of bandwidth and not make use of any SQL indexing. Surely this would be more efficient:

Load

;

SQL Select *

From DataBase

Where Dimension <> 'Adoption'

;

Re: remove rows

Thu, 20 Mar 2014 14:15:24 GMT

Yup. Absolutely true