Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Partitioning BIG Fact QVD file into multiple QVD Files?

Hi Members,

I have more than 600 million records in one of my fact tables and this table holds exactly 2 years of data in my DWH which is having daily partition in SQL Server DWH DB. So In SQL Server DB, I have total 730 partitions for this fact table.

Question arises, is that possible to partition QVD file? If yes I would like to partition my fact QVD into 8 quarters (2 years of data) so that we should not face any performance issue. Maximum users browse recent 3, 6 months data but few users go for 1 year or 2 years data.

2nd query, What would be the script in dashboard which should dynamically point to right partition based on user selection.

If anyone has done any such implementation please provide steps and script if any.

Message was edited by: Shivendoo Kumar

3 Replies
MVP & Luminary
MVP & Luminary

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

Take a look at QlikView Components http://qlikviewcomponents.org to segment your QVDs. Specifically, the routine

  Qvc.SegmentedStore

If the correct segmentation is not available for you or you need help on syntax ask for help on the QVC User Forum at

Google Groups

-Rob

Not applicable

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

Hi Rob,

I have gone through the link you have provided. Before looking into code, I need to know the basic of QVD segmentation.

Could you please explain it in words?

My Architecture is DWH (SQL Server Sources)-->QVDs--->Dashboards


I was thinking that we should partition the QVD in 8 physical QVDs files like SALES_Q1 to SALES_Q8 and all will have 3 months of data. 


Is this possible of not? If yes then can you explain me how can I see the data just for Q1 in Dashboard and What script developer should write?

MVP & Luminary
MVP & Luminary

Re: Partitioning BIG Fact QVD file into multiple QVD Files?

Hi,

Check this link

http://community.qlik.com/message/556995#556995

Regards,

Jagan.