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: 
GauravKumar1
Contributor II
Contributor II

HELP

Dear Team,

i Stuck a requirement. Please help me for sort out this problem.

Requirement is

Suppose in my fact table

code      Sale

Z121       100

Z222       200

AND a code master contain a hierachy.like deatils

means code wise mapping details

z121     A

Z121     B

Z121      C

Z222       D

Z222       E

 

When i left join Code master to fact.THEN RESULT BELOW

 

CODE                   DEATILS                Sale

Z121                         A                         100

Z121                          B                         100

Z121                           C                        100

Z222                            D                        200

Z222                            E                       200

 

Requirement is when i left join code master to fact then deatils wise sale which is showing above it should be zero(0)

and z121 wise sale showing 100

z222 wise 200

output format i show you

 

CODEDETAILSSale
 Z121100
Z121A0
B0
C0
 Z222200
Z222D0
E0

 KINDLY HELP ME FOR SOLVING THIS ISSUE.

Labels (1)
4 Replies
GauravKumar1
Contributor II
Contributor II
Author

CODE DETAILS Sale
Z121 100
Z121 A 0
B 0
C 0
Z222 200
Z222 D 0
E 0
CODE WISE GROUP DEATILS
GauravKumar1
Contributor II
Contributor II
Author

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

GauravKumar1
Contributor II
Contributor II
Author

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

GauravKumar1
Contributor II
Contributor II
Author

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE