Discussion board where members can get started with QlikView.
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.
Please try below:
Where is null(Partner Group);
You will get below op:
View solution in original post
why don't you try something like
where len(trim([Partner Group]))>0