topic Expression in Title in QlikView

Expression in Title

Fri, 03 Jun 2011 20:39:39 GMT

I have th folowing expression in title:

='Asia Pacific (' & if( GetFieldSelections([Demise Year])='','All Years',GetFieldSelections([Demise Year])) &')'

When Demise Year is selected (2011 for instance) I am having Asia Pacific (2011) which is correct. When i clear all selection I expect to see

Asia Pacific(All Year) but I only have Asia Pacific()

Any help will be appreciated. Thanks

erichshiino — Fri, 03 Jun 2011 21:07:41 GMT

Try to make it like this:

='Asia Pacific (' & if( len(trim( GetFieldSelections([Demise Year]) ))=0,'All Years',GetFieldSelections([Demise Year])) &')'

maybe the result is not blank in this case, but a NULL which is different from blank (NULL <> NULL too)

Regards,

Erich

Fri, 03 Jun 2011 21:13:34 GMT

Thanks a lot Erich