Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Let data in dataset disappear

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi Darri,

Please try below:

Load ...

...

..

From Table1

Where is null(Partner Group);


You will get below op:

Partner NameIncomePartner Group


   Ögurvík               4.500  
   Coca-Puffs           25.483   

Thanks,

Arvind Patil

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

hello

why don't you try something like

load *

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

Highlighted
Partner
Partner

Hi Darri,

Please try below:

Load ...

...

..

From Table1

Where is null(Partner Group);


You will get below op:

Partner NameIncomePartner Group


   Ögurvík               4.500  
   Coca-Puffs           25.483   

Thanks,

Arvind Patil

View solution in original post