Dimension into an expression

[don_qlikview]

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

[maxgro]

and with

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

perhaps you have more than 1 item name for every row

[Anonymous]

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])