topic Syntax error in my code with 'isnull' in QlikView

Syntax error in my code with 'isnull'

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

I want to check if for a certain SURVEY ID there is any sounding correction report.

So if there is any Sounding date they will show a sounding correction report.

If there are no sounding date value it will show no sounding correction reports.

I encountered a syntax error in my following code:

if( isNull([SOUNDING_START_DATE]) ,'No Sounding Correction Report Available','Sounding Correction Report Available');

Here SOUNDING_START_DATE IS A DIMENSION

trdandamudi — Wed, 22 Aug 2018 11:06:01 GMT

Give a try as below:

if( Len(Trim([SOUNDING_START_DATE])))=0 ,'No Sounding Correction Report Available','Sounding Correction Report Available');

jayaramp — Fri, 24 Aug 2018 08:24:55 GMT

In addition to Raja's suggestion above you need to store the output of IF condition into a field / dimension using "AS".

if( Len(Trim([SOUNDING_START_DATE])))=0 ,'No Sounding Correction Report Available','Sounding Correction Report Available') as ReptAvailable;

Here ReptAvailable is a new dimension.

Hope this is helpful.

Thanks.