Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-09-13 11:48 PM

TimeStamp Function

Could you please help me in converting following below BO query into Qlikview

TIMESTAMPDIFF(4, char(TIMESTAMP(( (CASE WHEN(1-1=0) THEN (TIMESTAMP(current date, current time)) ELSE

("HistoryTable".START_TIME) END) ))-TIMESTAMP(( "HistoryTable".END_TIME ))))

1,209 Views
0 Likes
1 Reply
Not applicable
‎2011-09-14 05:21 AM
Author

Hi,

the chunk of code

TIMESTAMPDIFF(4, char(TIMESTAMP(( (CASE WHEN(1-1=0) THEN (TIMESTAMP(current date, current time)) ELSE

("HistoryTable".START_TIME) END) ))-TIMESTAMP(( "HistoryTable".END_TIME ))))

is basically trying to calculate the difference in dates "HistoryTable".START_TIME and "HistoryTable".END_TIME.

You can use

Load  ("HistoryTable".END_TIME - HistoryTable".START_TIME ) as DiffDays from table..

in qlikview, but needs to take care of the system date fromat and date format of the data in the table.

As you know when you load date in Qlikview it will interpret the date in the local system date fromat that you can see in the first tab of the script.

Cheers.

376 Views
0 Likes