topic Re: Using a qvw template to build multiple qvw's in QlikView

Using a qvw template to build multiple qvw's

Wed, 09 Sep 2015 12:19:09 GMT

Hi all,

First time poster to the Qlik Community having recently become involved with Qlikview.

I was wondering if any developer out there had any experience of using a qvw template to build multiple qvw's?

I will try to explain it better - we have 100+ stores that use the same qvw format but each qvw will contain individual data that is particular to each store meaning that no other store can see individual data. We want to have a master template so that any changes that are made to the template will be made available to each individual qvw across all stores. I have tried to research this but alas no joy.

Hopefully there are some Cube Masters out there that can help with my plight and any help will be greatly appreciated.

If anymore clarification is needed please let me - I got a little confused when writing this myself.

Thanks!

Re: Using a qvw template to build multiple qvw's

marcus_sommer — Wed, 09 Sep 2015 14:32:10 GMT

To use a master-qvw as template and creating themes for documents/sheets/objects is a good practice to gain a consistent layout and usability - but in your case you will be more need a data-restriction within one single application (unless they is very big). This could be solved in qlikview with the approach of Section Access.

- Marcus

Re: Using a qvw template to build multiple qvw's

Thu, 10 Sep 2015 07:50:06 GMT

Thanks Marcus - but the issue is that the we are dealing with transactional data and for each week we would have over 300,000 lines to import and it will be very resource hungry if we load that in for all stores. We had thought of creating a python script that replicates the master qvw for each store and based on the variables passed in by a control file and only display the data relevant for the individual store. I was wondering if that was something anyone had tried before or if it was even viable!

Re: Using a qvw template to build multiple qvw's

vikasmahajan — Thu, 10 Sep 2015 08:00:21 GMT

Hii,

Brian , as Mr.Marcus suggests you can create master template then do loop and reduce on stores field, so that after reload qlikview will create multiple qvws for each store and can be utilize the respective qvw to respective store person.

Vikas

Re: Using a qvw template to build multiple qvw's

marcus_sommer — Thu, 10 Sep 2015 08:11:39 GMT

It would be depend on your entire environment (hardware ressources, number of applications and users, amounts of data total, kind of data and the applied datastructures) what is the best way but if possible applications should rather not split in that way else the use of section access or loop and reduce (by using publisher) is recommended.

If your environment isn't very small or with other applications already on his limits it should work fast enough within one single app - it are only 15 M records in a year. How many years would you need to provide on this transactional level?

- Marcus

Re: Using a qvw template to build multiple qvw's

Thu, 10 Sep 2015 10:24:27 GMT

Thank you Marcus_Sommer‌ & vikasmahajan‌ very much for your input!

I think we will use the loop and reduce method - it seems to be perfect for what I need. You guys rock!

Re: Using a qvw template to build multiple qvw's

vikasmahajan — Thu, 10 Sep 2015 10:26:56 GMT

Thanks

Vikas Mahajan