topic Turn IF Expression to Calculated Dimension in QlikView

Turn IF Expression to Calculated Dimension

Thu, 10 Sep 2015 15:51:13 GMT

Hi,

I'm trying to turn the following expression in a straight table to a calculated dimension. I can't get the syntax right. Can anyone help?

=If(Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) > 0, [Territory Name],Null())

Thanks!

ramoncova06 — Thu, 10 Sep 2015 15:56:34 GMT

whenever you use an aggregation as part of a calculated dimension you need to use aggr

aggr(only({<[Territory Name] = {"Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) > 0"}>} [Territory Name]),[Territory Name])

Thu, 10 Sep 2015 15:56:57 GMT

Try Like below:

IF( Aggr( Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) , [Territory Name]) > 0 , [Territory Name] )