topic Re: Stacked QVD Example Files in QlikView

Stacked QVD Example Files

Anonymous — Fri, 01 May 2015 15:58:15 GMT

Hi All!

I'm trying to track some historical data from SalesForce in Qlikview. We're wanting to be able to see history from weekly, monthly, quarterly, annually. Using the historical tables in SF.com don't seem to be doing the trick as we've used some customization and are not storing that data.

I haven't been able to come across much good reading materials for Stacked QVD's that have explained how they're implemented, but from what I've read this seems to make the most sense. Does anyone have any 'Case Study' examples of how the stacked QVD's are used and implemented so I can try and work through this?

Also - can stacked QVD's be used in the same application as a QVD that updates nightly? Being as I'm looking at the same fields from the same data source in different time periods, won't that cause synthetic key issues? Maybe I just need to see how this works first.

Any help is greatly appreciated!

Thanks!

Re: Stacked QVD Example Files

petter — Fri, 01 May 2015 16:12:10 GMT

In the QlikView Reference Manual.PDF-file you find on page 412 section 28.4 - Using QVD Files for Incremental Load a description of different scenarios and code to go with it too.

Furthermore:

Stephen Redmond's book "Master QlikView" is an excellent source for learning more about it. In chapter 3. Best Practices for Load Data there is a section called Mastering loading techniques which covers incremental load very thoroughly.

Re: Stacked QVD Example Files

ramoncova06 — Fri, 01 May 2015 17:29:00 GMT

here is a post from HIC where he explains about using different granularities in QV

Fact Table with Mixed Granularity

another option to incremental loads

QlikView Addict: QlikView Binary Loads

http://www.analyticsvidhya.com/blog/2015/03/qlikview-binary-load/