Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
crichter14
Creator
Creator

Translations in the Load Script

My company is doing training sessions and each one has a Session_Name.  They have Session_ID's but those aren't unique.

Some of the names for the same course(s) are in German and Polish.  I need a way, in the load script, to translate from German to English, Polish to English.  I can use an if statement, but I'm afraid they will keep adding new sessions and new names so I need a way to let them put the data in excel sheet and translate it in the load script.

I know there are ways to do it in Qlik View, but I need Qlik Sense please.  

I'm considering a mapping load from an excel file - but I've not used one before.  Can someone help me map it out - or point me to Qlik Sense post?

Thank you!

c

 

IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'LAGERBESTAND NEU ERFINDEN: LAGER-STRATEGIEN', 'REINVENTING INVENTORY: STOCK STRATEGIES',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'PONOWNE SPOJRZENIE NA ASORTYMENT: STOCK STRATEGIES', 'REINVENTING INVENTORY: STOCK STRATEGIES',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'AUFSTEHEN UND WACHSEN: ERFOLGREICHE VERÄNDERUNG', 'RISE AND THRIVE: LEADING CHANGE',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'WZRASTAJ I ROZWIJAJ SIĘ : WIODĄCA ZMIANA', 'RISE AND THRIVE: LEADING CHANGE',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'DIE ZUKUNFT IST JETZT: GERÜSTET FÜR DEN ERFOLG', 'THE FUTURE IS NOW: EQUIPPED FOR SUCCESS',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'PRZYSZŁOŚĆ JEST TERAZ: BĄDŹ PRZYGOTOWANA NA SUKCES', 'THE FUTURE IS NOW: EQUIPPED FOR SUCCESS',
UPPER(SUBFIELD("Session Title",' - ',1))))))))
AS SESSION_NAME,

Labels (6)
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

I think mapping load is the the same in QlikView script vs Qlik Sense, detailled here;

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/use-mappi...

So you would do something like in the toy application attached.

Cheers,

Chris.

View solution in original post

2 Replies
chrismarlow
Specialist II
Specialist II

Hi,

I think mapping load is the the same in QlikView script vs Qlik Sense, detailled here;

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/use-mappi...

So you would do something like in the toy application attached.

Cheers,

Chris.

crichter14
Creator
Creator
Author

Exactly what I needed Chris!  I did not want to hard code this.  Someone explained Mapping Load to me, like a vlookup.  I've always had a hard time with the syntax.  ApplyMap('Translation', phrase, null()) as Translation;  So let me ask you this.  In this apply map is null() the default if there's no match?

Thank you so much!