Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

akpofureenughwu
Contributor II

Year in number format

Good day everyone.

I have a set of data like this

StaffProgramme NameLocationYearCost
Jhon LeeIICTForeign201245,000
Paul BeckITILLocal201145,500
Jhon LeeRedHatLocal201134,000

I have designed a line chart using

Staff, Year as the  drill down dimension and //num(count({<Location = {'Local'}>} DISTINCT [Programme Name]), '#,##0') and num(count({<Location = {'Foreign'}>} DISTINCT [Programme Name]), '#,##0') as measures

When I drill down from staff to year.. the year is expressed as 2.011k, 2.012k. I don't know why?

Please see attached file for visuals 

1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Year in number format

Hi,

from the line chart properties, under aspect-> X Axis, uncheck "use continuous scale" .

2017-08-02 13_37_21-WM - Silca Web Marketing 2.1 - Il mio nuovo foglio _ Fogli - Qlik Sense.png

3 Replies
micheledenardi
Valued Contributor

Re: Year in number format

Hi,

from the line chart properties, under aspect-> X Axis, uncheck "use continuous scale" .

2017-08-02 13_37_21-WM - Silca Web Marketing 2.1 - Il mio nuovo foglio _ Fogli - Qlik Sense.png

akpofureenughwu
Contributor II

Re: Year in number format



Michele grazie

tomasz_tru
Valued Contributor

Re: Year in number format

Set X-Axis to 'continious'.