Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

DataModel

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

1 Solution

Accepted Solutions
vishalarote
Partner
Partner

6 Replies
delroekid
Creator
Creator

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
Creator III
Creator III

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
Master
Master

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
Partner
Partner

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
Partner
Partner

PFA,

Is it Ok?

soniasweety
Master
Master
Author

thanks all vishalarote

I need to calculate

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

how to calculate this?