topic Re: Timezone effecting available values on list box in QlikView https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305926#M844989 <HTML><HEAD></HEAD><BODY><P>The system time zone is GMT-5</P><P></P><P>Do you understand where is the problem?</P></BODY></HTML> Thu, 30 Mar 2017 08:53:29 GMT Anonymous 2017-03-30T08:53:29Z Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305924#M844987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am experiencing an issue that I can't understand,</P><P>when I look on the BI report (on access point), the selection calendar shows all dates:</P><P><IMG alt="1.png" class="jive-image image-1" height="202" src="https://community.qlik.com/legacyfs/online/158176_1.png" style="height: 202.258px; width: 403px;" width="403" /></P><P>but, when another user (from different time zone GMT-5) looks on the same calendar sees:</P><P><IMG alt="2.png" class="jive-image image-2" height="193" src="https://community.qlik.com/legacyfs/online/158177_2.png" style="height: 192.536px; width: 403px;" width="403" /></P><P>the 28th is missing :-0 </P><P></P><P>why is this happening? If I change my time zone from GMT+2 to GMT-5 I cant see it as well,</P><P></P><P>the BI server is GMT-5 as well</P><P></P><P>help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305924#M844987 Anonymous 2020-11-25T16:16:04Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305925#M844988 <HTML><HEAD></HEAD><BODY><P>Can you let me know the System time zone?</P><P></P><P>May be use this - <SPAN style="color: #000000; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;"><STRONG>ConvertToLocalTime(DateField, 'UTC')</STRONG></SPAN></P><P></P><P>Look more on UTC - <A href="https://www.timeanddate.com/worldclock/timezone/utc" title="https://www.timeanddate.com/worldclock/timezone/utc">Current UTC — Coordinated Universal Time</A></P></BODY></HTML> Thu, 30 Mar 2017 03:58:09 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305925#M844988 Anil_Babu_Samineni 2017-03-30T03:58:09Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305926#M844989 <HTML><HEAD></HEAD><BODY><P>The system time zone is GMT-5</P><P></P><P>Do you understand where is the problem?</P></BODY></HTML> Thu, 30 Mar 2017 08:53:29 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305926#M844989 Anonymous 2017-03-30T08:53:29Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305927#M844990 <HTML><HEAD></HEAD><BODY><P>Hi Nir,</P><P></P><P>Could it be because 28-Mar-2017 has not yet occured at the place/timezone where your BI-Server is located?</P></BODY></HTML> Thu, 30 Mar 2017 09:22:11 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305927#M844990 karthiksrqv 2017-03-30T09:22:11Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305928#M844991 <HTML><HEAD></HEAD><BODY><P>it did occur</P></BODY></HTML> Thu, 30 Mar 2017 10:05:35 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305928#M844991 Anonymous 2017-03-30T10:05:35Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305929#M844992 <HTML><HEAD></HEAD><BODY><P>Hi Nir,</P><P></P><P>It could be linked to the time-zone of the 'USER', since the control runs off the browser. It may not be dependent on your BI Server's timezone.</P></BODY></HTML> Thu, 30 Mar 2017 10:09:57 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305929#M844992 karthiksrqv 2017-03-30T10:09:57Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305930#M844993 <HTML><HEAD></HEAD><BODY><P>Are these calendar objects linked to fields?</P></BODY></HTML> Thu, 30 Mar 2017 12:18:21 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305930#M844993 Peter_Cammaert 2017-03-30T12:18:21Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305931#M844994 <HTML><HEAD></HEAD><BODY><P>yes,</P><P>the max value is defined as: <STRONG>= Max( {1}&nbsp; [Click Date])</STRONG></P><P><IMG alt="3.png" class="jive-image image-1" height="275" src="https://community.qlik.com/legacyfs/online/158293_3.png" style="height: 275.032px; width: 490px;" width="490" /></P></BODY></HTML> Thu, 30 Mar 2017 12:23:48 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305931#M844994 Anonymous 2017-03-30T12:23:48Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305932#M844995 <HTML><HEAD></HEAD><BODY><P>Which version and SR of QV?</P><P></P><P>-Rob</P></BODY></HTML> Thu, 30 Mar 2017 12:39:08 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305932#M844995 rwunderlich 2017-03-30T12:39:08Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305933#M844996 <HTML><HEAD></HEAD><BODY><P>12 SR5</P></BODY></HTML> Thu, 30 Mar 2017 12:47:09 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305933#M844996 Anonymous 2017-03-30T12:47:09Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305934#M844997 <HTML><HEAD></HEAD><BODY><P>Any section access in force?</P><P></P><P>-Rob</P></BODY></HTML> Thu, 30 Mar 2017 12:58:16 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305934#M844997 rwunderlich 2017-03-30T12:58:16Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305935#M844999 <HTML><HEAD></HEAD><BODY><P>yes, on the sheet level</P></BODY></HTML> Thu, 30 Mar 2017 13:43:53 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305935#M844999 Anonymous 2017-03-30T13:43:53Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305936#M845002 <HTML><HEAD></HEAD><BODY><P>Using Section Access data reduction? Is it possible the dates are getting reduced out?</P><P></P><P>-Rob</P></BODY></HTML> Thu, 30 Mar 2017 17:12:41 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305936#M845002 rwunderlich 2017-03-30T17:12:41Z Re: Timezone effecting available values on list box https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305937#M845004 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/133605">Change Timezone based on User Selection</A></P></BODY></HTML> Thu, 30 Mar 2017 17:40:00 GMT https://community.qlik.com/t5/QlikView/Timezone-effecting-available-values-on-list-box/m-p/1305937#M845004 MK9885 2017-03-30T17:40:00Z