Run the app independent of the script in QlikSense

[#1]

Hello All,

I am trying to figure out to make an app run independent of the script. Suppose I make a app say 'Attendance System' for a Client 'A'. Client A has given me the data in the form of an excel sheet. I load all the columns of the excel, create visualizations and then publish the app. Now there are two other clients (B,C) who has the same requirements and needs the same kind of app published but the name of their excel columns differs.  Say for example.. :

              Client A                                                       

Employee ID	Employee Name	Working Days

            Client B                                                       

DAS ID	Name	Billable days

              Client C                                                      

ID	EName	Days

I want to use the same app to accommodate Client B  and many more such clients without having to change the field names (of Client A) used in the visualizations.

[Gysbert_Wassenaar]

That's not possible. Your source files contain different field names. Therefore your load statements will create tables with those different field names. You'll have to change the field names in the visualizations.

[ift_isabelle]

You will have to change the names somewhere, but you can do that in the script.

Clients:

Load

     ID,

     Name,

     Days,

     'Client A' as Client

From [ClientA.xlsx];

Concatenate(Clients)

Load

     "DAS ID" as ID,

     Name,

     "Billable Days" as Days,

     'Client B' as Client

From [ClientB.xlsx];

Concatenate(Clients)

Load

      ID,

     EName as Name,

     Days,

     'Client C' as Client

From [ClientC.xlsx];

If they shouldn't see each others data, you can use section access to precent that:

Section Access