topic Re: DataModel in QlikView

DataModel

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

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 — Fri, 20 Apr 2018 05:38:37 GMT

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 — Fri, 20 Apr 2018 05:51:52 GMT

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 — Fri, 20 Apr 2018 06:05:01 GMT

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 — Fri, 20 Apr 2018 06:17:30 GMT

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 — Fri, 20 Apr 2018 06:30:27 GMT

PFA,

Is it Ok?

soniasweety — Fri, 20 Apr 2018 09:19:54 GMT

thanks all vishalarote‌

I need to calculate

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

how to calculate this?