topic Re: Autocalendar in Sense 3.0 in App Development https://community.qlik.com/t5/App-Development/Autocalendar-in-Sense-3-0/m-p/1159763#M21010 <HTML><HEAD></HEAD><BODY><P>I agree with Pascal. Also want to know.</P></BODY></HTML> Wed, 22 Nov 2017 07:35:42 GMT Anonymous 2017-11-22T07:35:42Z Autocalendar in Sense 3.0 https://community.qlik.com/t5/App-Development/Autocalendar-in-Sense-3-0/m-p/1159762#M21009 <HTML><HEAD></HEAD><BODY><P>Unfortunately, it seems there's no improvement in Autocalendar feature in Qlik Sense 3.0.</P><P></P><P>There's no way to have a year comparison using dual function as the value displayed is the year but the calculated value is a date (first day of the year). So, in demonstration there's no easy way to rapidly have that kind of comparison</P><P></P><P>script generated :</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14673856368312012 jive_text_macro" jivemacro_uid="_14673856368312012"> <P>Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),</P> </PRE><P></P><P>works nice with this syntax :</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14673859572258589 jive_text_macro" jivemacro_uid="_14673859572258589" modifiedtitle="true"> <P>&nbsp; Year($1) AS [Year] Tagged ('$axis', '$year'),</P> </PRE><P></P><P>It would be nice too to choose the calendar language and if we need or not a calendar on each date fields.</P><P></P><P>Of course, we can break the generated script... but not so friendly to use.</P><P></P><P>But I've perhaps missed something ?</P></BODY></HTML> Fri, 01 Jul 2016 15:18:43 GMT https://community.qlik.com/t5/App-Development/Autocalendar-in-Sense-3-0/m-p/1159762#M21009 pascal_theurot 2016-07-01T15:18:43Z Re: Autocalendar in Sense 3.0 https://community.qlik.com/t5/App-Development/Autocalendar-in-Sense-3-0/m-p/1159763#M21010 <HTML><HEAD></HEAD><BODY><P>I agree with Pascal. Also want to know.</P></BODY></HTML> Wed, 22 Nov 2017 07:35:42 GMT https://community.qlik.com/t5/App-Development/Autocalendar-in-Sense-3-0/m-p/1159763#M21010 Anonymous 2017-11-22T07:35:42Z