topic Re: Different date formats for different users? in App Development

Different date formats for different users?

quriouss — Tue, 01 Sep 2015 10:08:46 GMT

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.

Re: Different date formats for different users?

lironbaram — Tue, 01 Sep 2015 10:46:49 GMT

yes you can do something like

date(DateField , if(UserOffice = 'Chicago' , 'MM-dd-yyyy' , 'dd-MM-yyyy'))

Re: Different date formats for different users?

quriouss — Tue, 01 Sep 2015 10:55:32 GMT

Thanks.

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?

Re: Different date formats for different users?

lironbaram — Tue, 01 Sep 2015 13:25:12 GMT

hi for the user you can use the function

osuser() which will return the current user details as

Domain\UserName

but if you need the home office i think you'll need to load the this data to your qlikview model