Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Run the app independent of the script in QlikSense

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 NameWorking 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.

2 Replies

Re: Run the app independent of the script in QlikSense

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
Contributor II

Re: Run the app independent of the script in QlikSense

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