Can a dimension reference an expression value

Tue, 22 Jul 2014 20:06:27 GMT

I am trying to add a calculated dimension such that if the evaluated expression for my "Expressions" column is a certain value, I want the dimension to display null so that I can supress it and the row will not display. There doesn't seem to be a way to do this and for Expression columns, you can not suppress a row if it is null, you can only hide the column entirely.

example: = if ( [Bucket] != 'NA', FIRM_NAME, null())

Thanks in advance.

Re: Can a dimension reference an expression value

MK_QSL — Tue, 22 Jul 2014 20:50:56 GMT

= if ( [Bucket] <> 'NA', FIRM_NAME, null())

If(Aggr(sum(Bucket),FIRM_NAME)<>0,FIRM_NAME)

topic Can a dimension reference an expression value in QlikView

Can a dimension reference an expression value

Re: Can a dimension reference an expression value