topic Year in number format in App Development https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336456#M29321 <HTML><HEAD></HEAD><BODY><P>Good day everyone. </P><P></P><P>I have a set of data like this </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Staff</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Programme Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Location</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Cost</TH></TR><TR><TD style="padding: 2px;">Jhon Lee</TD><TD style="padding: 2px;">IICT</TD><TD style="padding: 2px;">Foreign</TD><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">45,000</TD></TR><TR><TD style="padding: 2px;">Paul Beck</TD><TD style="padding: 2px;">ITIL</TD><TD style="padding: 2px;">Local</TD><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">45,500</TD></TR><TR><TD>Jhon Lee</TD><TD>RedHat</TD><TD>Local</TD><TD>2011</TD><TD>34,000</TD></TR></TBODY></TABLE><P></P><P></P><P>I have designed a line chart using</P><P></P><P>Staff, Year as the&nbsp; drill down dimension and //num(count({&lt;Location = {'Local'}&gt;} DISTINCT [Programme Name]), '#,##0') and num(count({&lt;Location = {'Foreign'}&gt;} DISTINCT [Programme Name]), '#,##0') as measures </P><P></P><P>When I drill down from staff to year.. the year is expressed as 2.011k, 2.012k. I don't know why? </P><P></P><P>Please see attached file for visuals&nbsp; </P></BODY></HTML> Wed, 02 Aug 2017 11:12:18 GMT akpofureenughwu 2017-08-02T11:12:18Z Year in number format https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336456#M29321 <HTML><HEAD></HEAD><BODY><P>Good day everyone. </P><P></P><P>I have a set of data like this </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Staff</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Programme Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Location</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Cost</TH></TR><TR><TD style="padding: 2px;">Jhon Lee</TD><TD style="padding: 2px;">IICT</TD><TD style="padding: 2px;">Foreign</TD><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">45,000</TD></TR><TR><TD style="padding: 2px;">Paul Beck</TD><TD style="padding: 2px;">ITIL</TD><TD style="padding: 2px;">Local</TD><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">45,500</TD></TR><TR><TD>Jhon Lee</TD><TD>RedHat</TD><TD>Local</TD><TD>2011</TD><TD>34,000</TD></TR></TBODY></TABLE><P></P><P></P><P>I have designed a line chart using</P><P></P><P>Staff, Year as the&nbsp; drill down dimension and //num(count({&lt;Location = {'Local'}&gt;} DISTINCT [Programme Name]), '#,##0') and num(count({&lt;Location = {'Foreign'}&gt;} DISTINCT [Programme Name]), '#,##0') as measures </P><P></P><P>When I drill down from staff to year.. the year is expressed as 2.011k, 2.012k. I don't know why? </P><P></P><P>Please see attached file for visuals&nbsp; </P></BODY></HTML> Wed, 02 Aug 2017 11:12:18 GMT https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336456#M29321 akpofureenughwu 2017-08-02T11:12:18Z Re: Year in number format https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336457#M29322 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>from the line chart properties, under aspect-&gt; X Axis, uncheck "use continuous scale" .</P><P><IMG alt="2017-08-02 13_37_21-WM - Silca Web Marketing 2.1 - Il mio nuovo foglio _ Fogli - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/172195_2017-08-02 13_37_21-WM - Silca Web Marketing 2.1 - Il mio nuovo foglio _ Fogli - Qlik Sense.png" style="height: auto;" /></P></BODY></HTML> Wed, 02 Aug 2017 11:39:12 GMT https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336457#M29322 micheledenardi 2017-08-02T11:39:12Z Re: Year in number format https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336458#M29323 <HTML><HEAD></HEAD><BODY><P><SPAN lang="it"><BR /></SPAN></P><P><SPAN lang="it"><BR /></SPAN></P><P><SPAN lang="it">Michele grazie</SPAN></P></BODY></HTML> Wed, 02 Aug 2017 11:41:47 GMT https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336458#M29323 akpofureenughwu 2017-08-02T11:41:47Z Re: Year in number format https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336459#M29324 <HTML><HEAD></HEAD><BODY><P>Set X-Axis to 'continious'.</P></BODY></HTML> Wed, 02 Aug 2017 11:43:47 GMT https://community.qlik.com/t5/App-Development/Year-in-number-format/m-p/1336459#M29324 tomasz_tru 2017-08-02T11:43:47Z