topic Re: Where Exist Clause in QlikView

Where Exist Clause

Wed, 12 Nov 2014 13:16:06 GMT

Hi All

I have a scrip below...

Load
BIUNIQUEID,
IF([Termination Date] <= Today(), 'Terminated',
IF(InMonth([Termination Date],Today(),0),'This Month',
IF(InMonth([Termination Date],Today(),1),'Next Month',
IF(InMonth([Termination Date],Today(),2),'2 Month',
IF(InMonth([Termination Date],Today(),3),'3 Month', 'More Than 3 Months')))))as Flag
Resident STAFF;

For the last "If" statement, in the "Else" part (More Than 3 Months), I only want to return records where [Termination Date] exist.

How can I do this?

Re: Where Exist Clause

Gysbert_Wassenaar — Wed, 12 Nov 2014 13:18:44 GMT

This will load only records that have a Termination Date value:

WHERE len(trim([Termination Date]));

This will load all records, but leave the Flag field empty if the record has no value in the Termination Date field

Re: Where Exist Clause

Wed, 12 Nov 2014 13:52:56 GMT

Hi Gysbert

Thanks for your solutions!

Your solutions are always precise and effective. I appreciate your great support in my journey of learning this awesome BI tool called QlikView