topic Re: Two Fact Table in QlikView

Two Fact Table

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

This in QlikView.

I have two Fact table in my model:

Sales: DateKey and Sales

Plan: DateKey, ProductKey and Plan

and we have Product master data table.

My Pivot table should have below fields:

Date, Product Group, Sales and Plan.

If we make concatenate of those two table. Will my purpose be fulfill?

Please suggest.

Thanks,

Sarif

Re: Two Fact Table

ramasaisaksoft — Fri, 17 Feb 2017 09:24:16 GMT

Sorry Mohammad we didn't understand your requirement properly.

Could you please elaborate/Expand requirement and specify required output.

Re: Two Fact Table

mhmmd_srf — Fri, 17 Feb 2017 09:31:05 GMT

Hello Rama,

We have two Fat Tables. One is Sales and another is Plan.

Sales: DateKey and Sales Value

Plan: DateKey, ProductKey and Plan Value

However in chart we need to show Date, Product, Sales Value and Plan Value. Where Sales Value and Plan Value is coming from two different tables.

So what would be the way to handle this situation.

I was thinking to concatenate two Fact tables. Is it right way?

Please advice.

Thanks,

Sarif

Re: Two Fact Table

sdmech81 — Fri, 17 Feb 2017 09:34:42 GMT

Yeah,,

Since sales r plans r 2 different entities u can concatenate them..

Something like:

Fact:

load datekey,

Sales,

'sales' as salesflag

........................

from sales.qvd

concatenate

load datekey,

Product_key,

Plan

'Plan' as PlanFalg

........................

From paln.qvd;

Product master:

Load * from product master.qvd..

Product master will asscociate with fact through product_key

Let me know if not clear..

Sachin

Re: Two Fact Table

sdmech81 — Fri, 17 Feb 2017 09:36:05 GMT

2 flags created i.e salesflag and palnflag will help u while handling In sets..

Sachin

Re: Two Fact Table

khalander — Fri, 17 Feb 2017 09:42:23 GMT

Hi,

Instead of concatenate try to join two tables if you have one matching key

Re: Two Fact Table

mhmmd_srf — Fri, 17 Feb 2017 09:53:20 GMT

okk... but my understanding is the field name of the flag should be same. Not different like Sales Flag and Plan Flag.

I think it should be only flag.

Is my understanding correct?

Please help.

Thanks,

Sarif

Re: Two Fact Table

MayilVahanan — Fri, 17 Feb 2017 09:58:40 GMT

Hi Mohammad,

You can go with Join instead of Concatenate..

For your scenario, Flag is not required anymore. Because you have different type of KPI (Plan and Sales).

Re: Two Fact Table

sdmech81 — Fri, 17 Feb 2017 11:39:56 GMT

Hi,

In ur case Is that Date_key is the same fr both sales n plan table.

I don't think so bcs in real world scenario sales date and plan table dates r different..

That's why I suggested u the concatenate..If they r the same date u can go ahead with Join.

But do check bfr joining as I don't think its the same date bcs dates r generated ib DB so thr is going to b some difference aswell..If in both fact its the same date then u go ahead with join.

Sachin.

Re: Two Fact Table

sdmech81 — Fri, 17 Feb 2017 11:50:13 GMT

Better attach sample data so tht ppl can throw their views properly.

Sachin