translate to qlikview script

[mfikrirahmat]

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

[tamilarasu]

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'

                   )

               )

          )

       )