topic Re: IF Statement for a Dimension in Chart Properties in QlikView

IF Statement for a Dimension in Chart Properties

Anonymous — Wed, 18 Mar 2015 13:06:38 GMT

If a value is blank or null return blank...

I have a date 12/31/9999 12:00:00 AM and I would like to say if this date exist return blank for the rows...I cannot get this to work. Help?

Chart Properties>Dimensions>Enable Conditional

=IF(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt) Or

=IF(termDt= '12/31/9999 12:00:00 AM' ,'',termDt)

hic — Wed, 18 Mar 2015 13:12:06 GMT

You should probably do this in the script, e.g

If(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt) as termDt

HIC

buzzy996 — Wed, 18 Mar 2015 13:17:03 GMT

i think the problem with date format, can u try some thing like

=IF(termDt= date#(('12/31/9999 12:00:00 AM','the format of required datetime stamp') ,null(),termDt)

Anonymous — Wed, 18 Mar 2015 13:21:06 GMT

That worked, is there a way to remove the dash - from the data?

termDt

Wed, 18 Mar 2015 13:25:31 GMT

Hi,

First condition is correct in dimensions tab.

=If(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt)

maleksafa — Wed, 18 Mar 2015 13:36:33 GMT

select your dimension under the dimension tab and click on suppress when value is null

Anonymous — Wed, 18 Mar 2015 15:21:43 GMT

Remove the null values----> Presentation tab remove Null Symbol in box. Thank you all for the help