Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

margin flagging

Hi

Can some one help me with this formula:

  

ITEM_NOSalesMarginif((column(3) > 0),'Y','N')
ORI$1,067,241.25$417,707.08Y
ZZ$393,263.33$393,263.33Y
TSF$946,720.60$343,977.14Y
GLU$1,211,490.97$337,970.18Y
GLU$1,029,243.72$281,447.37Y
TER$37,228.43($18,822.36)Y
INB$4,921.72($18,998.05)Y
OSE$40,847.47($21,705.15)Y

I am trying to do:

if margin is negative then Y else if N.

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

to avoid confusion maybe

if([Margin]>0,'Y','N')

View solution in original post

2 Replies
Highlighted

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

Highlighted
Specialist
Specialist

to avoid confusion maybe

if([Margin]>0,'Y','N')

View solution in original post