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: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Trying to personalise my apps

Hi everyone.

I am trying to personalise my apps, i currently have a text box in the top left corner which welcomes the user ( Welcome - USER NAME). Is it possible for qlikview to recognise the time ? i.e if it's before 12:00 then instead of saying 'Welcome' it says 'Good morning'. and the same for a time frame being after 11:59am saying 'Good Afternoon'.

Is this possible or am i asking something silly?

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Please Mark this post as Answered.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

   Try below expression.

  

=if(text(time(now(),'hh:mm')) > '00:00' and text(time(now(),'hh:mm')) < '12:00','Good Morning',

if(text(time(now(),'hh:mm')) >= '12:00' and text(time(now(),'hh:mm')) < '16:00','Good Afternoon',

if(text(time(now(),'hh:mm')) >= '16:00' and text(time(now(),'hh:mm')) < '21:00','Good Evening','Good Night')))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

This is possible. You can use the Now() function whichreturn the current date & time. And then you use OSUser() function to getthe name of the user.

For example you might need to use something like this…

=IF(Now() >Sometime, “Good Morning”, “Hello”) & “ “OSUser()

You might need to tweak the function to get the format youwanted… For example, OSUser() shows the domain name so you might need to trimit.

Good luck!

Cheers - DV

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, thanks both, the If(Now( function worked great

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Please Mark this post as Answered.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
IAMDV
Luminary Alumni
Luminary Alumni

You are welcome! I strongly recommend you to look intosystem functions and you have more functions to customize the application.

Cheers - DV