Discussion board where members can get started with QlikView.
Can some one help me with this formula:
I am trying to do:
if margin is negative then Y else if N.
to avoid confusion maybe
View solution in original post
I am guessing that ITEM_NO is a dimension here? May be use Column(2) instead of Column(3)
If(Column(2) > 0, 'Y', 'N')