Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Data model

Can u please suggest on attached data model

Thanks

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

You have only two fields for Country Table..

Do Mapping Load and use ApplyMap to add Region in Sales Table..

Country:

Mapping LOAD country,

     Region

FROM

(biff, embedded labels, table is [Country Groupings$]);

Product:

LOAD productId,

     productName,

     stdCost,

     stdPrice

FROM

(biff, embedded labels, table is [Product Ledger$]);

Sales:

LOAD custId,

     custName,

     custCountry as country ,

     ApplyMap('Country',custCountry,'Unknown') as Region,

     productSold as productId ,

     salesChannel,

     unitsSold,

     dateSold

FROM

(biff, embedded labels, table is [Sales Data$]);

View solution in original post

9 Replies
sunny_talwar

What exactly do you need suggestion with Deepak?

awhitfield
Partner
Partner

Hi Deepak,

you really need to check: https://community.qlik.com/docs/DOC-7538 : Qlik Community Tip: Posting Successful Discussion Threads.

Andy

MK_QSL
MVP
MVP

This is Start Schema... Looks ok..!!

Edited : Star Schema..!!

Thanks

awhitfield
awhitfield
Partner
Partner

Or even a STAR SCHEMA -

Andy

deepakqlikview_123
Specialist
Specialist
Author

Hi All,

I just wanted some suggestion from you all.

need to chk if anything  else i can do.

Thanks

MK_QSL
MVP
MVP

Yes, you can close the thread if you got your answer...

MK_QSL
MVP
MVP

You have only two fields for Country Table..

Do Mapping Load and use ApplyMap to add Region in Sales Table..

Country:

Mapping LOAD country,

     Region

FROM

(biff, embedded labels, table is [Country Groupings$]);

Product:

LOAD productId,

     productName,

     stdCost,

     stdPrice

FROM

(biff, embedded labels, table is [Product Ledger$]);

Sales:

LOAD custId,

     custName,

     custCountry as country ,

     ApplyMap('Country',custCountry,'Unknown') as Region,

     productSold as productId ,

     salesChannel,

     unitsSold,

     dateSold

FROM

(biff, embedded labels, table is [Sales Data$]);

View solution in original post

vsudhakar
Creator III
Creator III

by using the join the tables than you get the than you get the one type of the model

salto
Specialist II
Specialist II

The only thing I would mention is the country field, which is not a perfect key.