Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all master qlikview
script from excel =IF(OR(G169=0,J169=0,Y169="",Z169=""),"",IF(AND(Z169>=5,Y169>=5),"Kuadran I",IF(AND(Z169<=5,Y169>=5),"Kuadran II",IF(AND(Z169<5,Y169<5),"Kuadran III","Kuadran IV"))))
please translate to qlikview script
Hi Mfikri,
=IF(G169=0 or J169=0 or Len(Y169)=0 or Len(Z169)=0, '',
IF(Z169>=5 and Y169>=5, 'Kuadran I',
IF(Z169<=5 and Y169>=5, 'Kuadran II',
IF(Z169<5 and Y169<5, 'Kuadran III', 'Kuadran IV'
)
)
)
)