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.
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
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
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.
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!
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
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
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?
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
