topic Re: Dimension into an expression in QlikView

Dimension into an expression

don_qlikview — Thu, 15 May 2014 19:17:05 GMT

Hello Everyone,

I need help with an if condition that I am writing in an expression. So, the condition is like this if(Sum(

[Sales]) > 0, [Item Name] & '*', [Item Name]). When I write
this condition I am only getting * not the field "Item Name". So, can somebody tell me how to get the field name too in th expression?

Thanks,

Don

Re: Dimension into an expression

maxgro — Thu, 15 May 2014 19:39:36 GMT

and with

maxstring([Item Name]) instead of [Item Name]?

perhaps you have more than 1 item name for every row

Re: Dimension into an expression

Anonymous — Thu, 15 May 2014 19:39:59 GMT

Don,

Blind guess (it would be better to see your application or at least data model):

You need this result per item, so:

aggr(if(Sum([Sales]) > 0, [Item Name] & '*', [Item Name]), [Item Name])