topic Re: Let data in dataset disappear in QlikView

Let data in dataset disappear

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, community

I have one issue that I am trying to resolve.

I have a really simple dataset.

I want to see if I could use some simple programming that throws out all the lines that have no Product Group.

The same as "Where Exists () function" does in QlikView script.

I want line number 4 which has Partner Name Ögurvík and Income 4.500 and line number 8 which has Partner Name Coca-Puffs and Income 25.483 to disappear because they have no Partner Group.

Partner Name	Income	Partner Group
HB Grandi	1.000	Fisk
Iceland Seafood	2.000	Fisk
Brim Seafood	3.500	Fisk
Ögurvík	4.500
Bonus	6.520	Food
Hagkaup	2.633	Food
Cherries	22.221	Food
Coca-Puffs	25.483
HB Grandi	215.536	Food

regards, Darri

Re: Let data in dataset disappear

olivierrobin — Thu, 12 Jul 2018 10:08:16 GMT

hello

why don't you try something like

load *

where len(trim([Partner Group]))>0

Re: Let data in dataset disappear

arvind_patil — Thu, 12 Jul 2018 10:09:35 GMT

Hi Darri,

Please try below:

Load ...

...

From Table1

Where is null(Partner Group);

You will get below op:

Partner Name

Income

Partner Group

Ögurvík

4.500

Coca-Puffs

25.483

Thanks,

Arvind Patil