Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

Datamodel split

HI experts,

Hi have one QVW in that applications i have around 25 kpi's are there. now i want split that data model. How is it possible to split the data model?

2 Replies
bindu_apte
Creator III
Creator III

Hi Prabhas,

It is depending on the application which you want to develop.

If possible share the sample qvw.

Siva_Sankar
Master II
Master II

Prabhas,

Splitting datamodel is good idea..


The idea behind document segmentation is that you produce a qvw that has summary data for all periods and detailed data for only a recent term.

For example, a sales app may have Sales numbers summarized by Region, Customer, Category and Month for 10 years, but line item detail for only the last 12 months. If the user needs to see line item detail for a prior year, they press a button that uses the "Open Qlikview Document" Action to open another qvw (document chaining) that has detail for that year.

The segmentation idea relies on being able to roll up to the smallest level of granularity required for long term analysis. I've found it will work in most cases, but you have to sit down and define the analysis scenarios with your users.

But you need to know how you want to do the segmentation or splitting the data model.

Regards,

Siva