topic SQL logic in Qlikview in QlikView

SQL logic in Qlikview

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

Need to implement this logic into qlikview

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

Please advice..

adamdavi3s — Thu, 25 Aug 2016 08:29:57 GMT

(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 — Thu, 25 Aug 2016 08:31:34 GMT

Hi,

maybe

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

HTH

André Gomes

qlikviewwizard — Thu, 25 Aug 2016 08:33:14 GMT

(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 — Thu, 25 Aug 2016 08:34:06 GMT

Why did you just copy and paste my answer?

teiswamsler — Thu, 25 Aug 2016 08:38:35 GMT

Hi Prashant

try this in script

Formula:

Load

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

Path y

;

/Teis