Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor II
Contributor II

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

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

Highlighted
Contributor II
Contributor II

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

Highlighted
Contributor II
Contributor II

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE