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.

Tags (1)
Labels (1)
4 Replies
Highlighted
Contributor II
Contributor II

Re: HELP

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

Re: HELP

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

Highlighted
Contributor II
Contributor II

Re: HELP

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE

Highlighted
Contributor II
Contributor II

Re: HELP

OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE