Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

converttolocaltime()

Hello All,

I have enries in my database as

Region Loaded_Dt

Houston 09/17/2009 15:00:00

Europe 09/17/2009 14:00:00

Singapore 09/17/2009 11:00:00

Dubai 09/17/2009 12:00:00

All these time stamps are local time zone timestamps.

What I need to create in a report is show Number of loads today

In this case it should be 1 load for each region for 09/17/2009

How do I adjust my expression for showing this as loaded for 24 hrs period (per region)

Can I use daynumberofyear(converttolocaltime(Today()) ) = daynumberofyear(loaded_dt)

and it will automatically adjust to 24 hour period match for that particular region where the report is opened?

i.e if i open the report in dubai does converttolocaltime() mean 24 hours for that particular region - does the report adjust this expression based on where it is opened?

Thanks for the help.

Labels (1)
0 Replies