topic Re: Exluding data in QlikView

Exluding data

Wed, 10 Jun 2015 13:56:25 GMT

Hi everyone!

Could you, please, help me with scripting the following. I want to exclude events (whole rows in the table) fitting two conditions:

1) value is equal to N,

2) number of "values equal to N" is counted more than 10.

For example, there is a field 'status' with values a) single, b) married and I want to keep only 10 single ones and to delete the others.

As far as I understood, I need to use WHERE function within LOAD. But I have no idea in which way it shoukd be scripted.

Could you, please, help me with that?

Thank you!

rakesh_kumar — Wed, 10 Jun 2015 14:24:32 GMT

Hi Marina,

Try like this:

Load top 10 *

from New.qvd (qvd)

where status = 'single';

Here I restricted to top 10 rows. If you vae any ID field then you can modify where statement like this:

where status = 'single' and ID<=10;

I hope this helps.

Regards,

Gysbert_Wassenaar — Wed, 10 Jun 2015 14:27:24 GMT

MyTable:

FIRST 10

LOAD * FROM ...source... WHERE Value = 'N';

Concatenate(MyTable)

LOAD * FROM ...source... WHERE Value <> 'N';

Wed, 10 Jun 2015 14:33:58 GMT

Many thanks, Rakesh and Gysbert!

May I write it this way:

... WHERE 'Field' ='value' <>'N' ?

Or this is incorrect?

Gysbert_Wassenaar — Wed, 10 Jun 2015 14:36:11 GMT

To follow your example of singles: WHERE status = 'single'. Make sure to use the exact case-sensitive field names and values.

Wed, 10 Jun 2015 14:37:13 GMT

Thank you so much, Gysbert!

oknotsen — Wed, 10 Jun 2015 21:23:27 GMT

If you consider the question answered, please flag the correct answer and close the topic.

If not, please make clear what other information you are still looking for.