Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

imrasyed
Contributor

Multiple Facts

Hi Experts,

I have sales and  Inventory tables.

I have concatenated both the fact tables and It is perfectly fine but the only thing is when i link Customer Dim table to fact table then I am getting Measure(Inventory)  whcih shd be zero.

.

Can you help me out how I can proceed in resolving this Issue?

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Multiple Facts

concatenate two tables

but  add flags in both the tables to get correct result in front end

Tab1:

load

A,

B ,

0 as Flag

from sql  ;

Tab2:

load

A,

B .,

c,

d,

1 as flag

from sql  ;

frontend:

=sum({<Flag={0}>}Inventory)

=sum({<Flag={1}>}Profit)

3 Replies
mdmukramali
Valued Contributor II

Re: Multiple Facts

Hi,

we need to have some more details about your Data Model.

so can you attached sample file with your existing Data Model

Thanks,

Mukram

sureshqv
Esteemed Contributor III

Re: Multiple Facts

concatenate two tables

but  add flags in both the tables to get correct result in front end

Tab1:

load

A,

B ,

0 as Flag

from sql  ;

Tab2:

load

A,

B .,

c,

d,

1 as flag

from sql  ;

frontend:

=sum({<Flag={0}>}Inventory)

=sum({<Flag={1}>}Profit)

imrasyed
Contributor

Re: Multiple Facts

I did that but My question is how to connect Customer Table to only sales fact table and not with the Inventory.

I just removed the Null values were creating the problem.

Thanks for your help.

Community Browser