Dear all,
while integrating and QlikView Dashboard to QlikSense, there has been the following issue, where I hope that someone is able to help me:
In QikView, the user is able to set variable dates (work begin/end) with and input box as well as setting the working time (begin/end) between 0-24h. The final output should be something like " Work from 20.10.20 08:00 until 20.10.20 18:00" but right now it does only show the date with zero time (00:00) wile integrating in Sense.
With following extension:
'Work from '&
Timestamp(Date('$(Date_Begin_Day)') &' '& Time('$(Date_Beginn_Hour)'/24),'DD.MM.YY hh:mm')
&' bis '&
Timestamp(Date('$(Date_End_Day)') &' '& Time('$(Date_End_Hour)'/24),'DD.MM.YY hh:mm')
Thanks in advance!