Discussion Board for collaboration related to QlikView App Development.
I have two fields in my data as follows:
Is it possible to change the date and time to the following when time is 00:00 (changes in highlighted in orange)
Go to Solution.
Yes, use Previous command..
IF(time(TimeField,'HH:MM')='00:00', Date(Previous(DateField),'YYYY.MM.DD'),DateField) as DateField
have you tried IF statement?
IF(time(TimeField,'HH:MM')='00:00', '24:00',TimeField) as TimeField
IF(time(TimeField,'HH:MM')='00:00', Date(DateField-1,'YYYY.MM.DD'),DateField) as DateField
For the date field, is it possible to take from previous record date rather than minus 1? This is because some dates are Mondays, and I want it to be Friday (i.e. the last record date) rather than Saturday (if using -1).
Thanks for your help!