Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Not applicable

DST Hadling in Qlikview

Hi All,

I'm working on a small project where I need to handle DST transistion dates. For example, consider the sample data set. At 26th October 02:00 hours, we have two sets of records. One belongs to CET timezone and other belongs to CEST timezone.

DST-Handling.GIF.gif

1. In such case, how to represent 02:00 hrs data in chart? What is the general standards? Should I take aggregate of the two sets of records per manufacturer/brand or drop one of the sets. I like to know the general standards followed.

2. Another question is what if I like to represent both 02:00 CET and 02:00 CST on line chart like below image. What change I should make?

DST-Handling_1.GIF.gif

2 Replies
Highlighted
Valued Contributor

Re: DST Hadling in Qlikview

Add a timezone field - this would probably be a lookup of some sort and use the hours() function for hours display as per enclosed. I have added the hours() to the script as you may wish to create days/weeks/months etc. too

I have attached an answer - Hope it helps

Highlighted

Re: Re: DST Hadling in Qlikview

Krishnakumar

Have a look at these QlikView functions :

ConvertToLocalTime

LocalTime

DaylightSaving