How to create a QV for 1 company and increase to 100 ?

[paulyeo11]

HI All

i like to know . If I have 100 All using SAP software .

Tlike to know it is possible I create for one company and use for all company ?

MY question is how to combine all company  into one ?

Meaning I have one QVW file for one company.

I Like to combine all 100 company QVW into one.

paul

[Anonymous]

Create generic QVD generators to create a set of QVD's for each company, then concatenate the QVD's together in a combined dashboard.

[Anil_Babu_Samineni]

I don't know of any way around the problem except storing as QVDs(As Bill Said). Iit shouldn't take very long to do the store. You can do it with a script loop like this:

BINARY Yourpath.qvw;

FOR i = 0 to NoOfTables()-1

  LET vTableName = TableName($(i));

  LET vOutfile = '$(vTableName).qvd';

  STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

[paulyeo11]

Hi Bill

For the generic QVD do you mean a template ? So I only need to use this generic change the SOURCE field name to COMPANY_A ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

[paulyeo11]

Hi Anil

Do you mean once I have 100 company sales table , you script will combine the 100 table into 1 right ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

[Anonymous]

For such scenarios I create a QVD generator which uses a spreadsheet with a row for each data source along with its connection string then loops around for each row to create the QVD for each company. 

[paulyeo11]

Hi Bill

Meaning your QVD Generator will generate 100 QVD file , each company have 1 QVD. It is ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

[Anil_Babu_Samineni]

Yes, But you should need to follow same structure to do this. No need to concatenate every time by using given script. It will stores single qvd and then future you can load This qvd into Qlikview and then once you choose country you will get 100 Countries of data at a time

[paulyeo11]

Hi Anil

I think what you and bill are talking on the same approach.

Instead of I need to have 100 script to generate 100 table.

Make use of excel file ( Bill mention ) with your script , I need only 1 script to load 100 company sales order table .

This will save a lot of time and easy to maintenance.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

[Anil_Babu_Samineni]

Then, You should maintain seperate folder for that Sales data and then use simple to load 100 companies sales into Qlikview

Like below by using * for all. This should stored in same path and same sheet then only it will work or you should folow samething as we mentioned on the Top

LOAD Country,

          Sales

FROM

[..\..\..\Users\user\Desktop\*.xls]

(biff, embedded labels, table is Sheet1$);