Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Please Mark this post as Answered.
Regards,
Kaushik Solanki
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
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
Hi, thanks both, the If(Now( function worked great
Hi,
Please Mark this post as Answered.
Regards,
Kaushik Solanki
You are welcome! I strongly recommend you to look intosystem functions and you have more functions to customize the application.
Cheers - DV