Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

create fact table

please download the attachment

and allow me to know .how to create fact table of these dimensions  table

thanks in advancesend.png

3 Replies

Re: create fact table

There is just master data in your three tables, meaning that they translate into dimensions. But the facts come from different tables (missing in your picture) like sales records, or customer calls, or shipments. Do you have any tables like that?

pokassov
Valued Contributor

Re: create fact table

Fact:

NoConcatenate Load

     *

resident

User;

Left Join (Fact)

Load

  *

Resident

  Target;

Left Join  (Fact)

Load

  *

Resident

  TargetClient;

DROP  Tables

  User, Target, TargetClient;

buzzy996
Honored Contributor II

Re: create fact table

there is no fact data in ur table ,whichever u shoed all are the dimension data.

in simple words,

facts means measure's(keys to help understand the business)

Community Browser