DataModel

[soniasweety]

Hi All,

I want to create a sample datamodel for this attached qvd's   and I have loaded the data  but am unable to create Datamodel

and I have multiple dates in table how to make it single  and that to link to master calendar .

Thanks

Sony

[Anonymous]

I can see a lot of synthetic keys and joins in your data model

you can try simplify with

- mapping

-renaming fields

- qualifying table fields

qlikview will automatically join same field names between tables

[chinnuchinni]

Hi,

once check the attache app.let me know if you need any clarity or modification.

1st you should check weather ur required data comming properly or not.

[shiveshsingh]

What is the logic for joining the tables? Is it only dependent on field names? what are the KPIs?

What type of data these QVD contains?

You need to derive the required fields and based on that model is prepared.

I hope you have heard about snowflake and Star schema, which model you want to follow in this? i can see more many synthetic keys in your model.

[vishalarote]

Create One fact Table Assign Some Flag to each table as Doctype n Concatenate that tables.

So it will show one fact table one Master Calender as Dimension Table.

and Make All Dates Field Alias as "Date".

Each Date Having Flag so Create Variables in Frontend

Suppose my Date is TRANSDATE so am alias to Date n Assign '1' as Flag or Doctype

Make Variable

set vTRANSDATE=Max({<Doctype={'1'}>}Date) in Frontend and use in expression like

e.g.

sum({<Date={"$(vTRANSDATE)"}>}Sales)

Hope So it will Help you.

[vishalarote · Accepted solution]

PFA,

Is it Ok?

[soniasweety]

thanks all vishalarote‌

I need to calculate

Requirement :-closed order turn around time [TAT]   based on transactions.  ?

how to calculate this?