We are looking at rolling out Qlik Sense for a Global Audience. Our American users are used to using mm-dd-yyyy as a date format, whereas Europeans are using dd-mm-yyyy. The data is all loaded into QlkSense in only one format.
What is a good way to deal with showing each group of users a filter box in their preferred format? I don't really want to start re-training a nation on how to enter dates.
Can we do something with the user's LDAP/ADS profile (if UserOffice = Chicago then DateFormat=mm-dd-yyyy) or do we have to get into publishing different versions of the data for the different audiences?
Many thanks in advance for sharing your experiences.
Do I have to import the users as a separate stage in the load script, or can I leverage the Active Directory connection which I'm already using? And at the risk of sounding lazy, do you happen to know the syntax/variables for Qlik to refer to the current user?