Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tomhovens
New Contributor II

Problems with date label Dygraphs

Hi All,

The X-axis label contains a Date (D/M/YYYY) but instead of showing 1/1/2015 etc I have the number. Anyone got an idea???

1 Solution

Accepted Solutions
kidbank3
Contributor III

Re: Problems with date label Dygraphs

Bruno is right.  Under graph options - Input data, set the x-axis to date.  Then match your raw data date format to what is used in the example app (YYYY/MM/DD).

Then you won't need to use a date function.  It will appear as (MMM YYYY) in your chart.

Mike

5 Replies
awhitfield
Esteemed Contributor

Re: Problems with date label Dygraphs

Can you upload a sample qvf?

Andy

kidbank3
Contributor III

Re: Problems with date label Dygraphs

try wrapping you dimension in a date function: date([datefield],'MM/DD/YYYY')

brunobertels
Valued Contributor

Re: Problems with date label Dygraphs

Hi

have you chek that :

x-Axis Data Type (Dimension 1) - The data type for values on the x-axis, provided by the first dimension. This may be set to either Numeric or Date. (default: Numeric)

and if it is set to Date ,

Try to use date function for your dimension

your dimension = date

date(date,'DD/MM/YYYY')

or date#(date,'DD/MM/YYYY')

bruno

tomhovens
New Contributor II

Re: Problems with date label Dygraphs

Yes I can

kidbank3
Contributor III

Re: Problems with date label Dygraphs

Bruno is right.  Under graph options - Input data, set the x-axis to date.  Then match your raw data date format to what is used in the example app (YYYY/MM/DD).

Then you won't need to use a date function.  It will appear as (MMM YYYY) in your chart.

Mike