Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

SQL logic in Qlikview

Dear All,


Need to implement this logic into qlikview

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

Please advice..

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

(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.

View solution in original post

5 Replies
adamdavi3s
Master
Master

(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
Specialist II
Specialist II

Hi,

maybe

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

HTH

André Gomes

qlikviewwizard
Master II
Master II

(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
Master
Master

Why did you just copy and paste my answer?

teiswamsler
Partner - Creator III
Partner - Creator III

Hi Prashant

try this in script

Formula:

Load

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

Path y

;

/Teis