Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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.


talk is cheap, supply exceeds demand
ift_isabelle
Partner - Creator III
Partner - Creator III

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