SQL logic in Qlikview

[prma7799]

Dear All,

Need to implement this logic into qlikview

(1 / NULLIF( a.[ABC], 0 ) ) * (  b.[XYZ])

Please advice..

[adamdavi3s · Accepted solution]

(1 / (IF(LEN( a.[ABC])>0,a.[ABC],0 ) ) * (  b.[XYZ])

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[agomes1971]

Hi,

maybe

(1 / if([a.[ABC]]=' ',  0, [a.[ABC]]) ) * (  b.[XYZ])

HTH

André Gomes

[qlikviewwizard]

(1 / (IF(LEN(trim( a.[ABC]))>0,a.[ABC],0 ) ) * (  b.[XYZ])

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question

[adamdavi3s]

Why did you just copy and paste my answer?

[teiswamsler]

Hi Prashant

try this in script

Formula:

Load

(1 / if( isnull(a.[ABC]), 0, a.[ABC]) ) *  b.[XYZ] as X

Path y

;

/Teis