Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

How to ensure date format in Qliksense

Hi

I'm new to Qliksense and having trouble displaying date dimensions in eg line charts.

A sample of the (CSV) data set looks like this:

  

Case noDate 1
case142075,52292
case242075,52639
case342075,51458
case442075,49583
case542075,51250
case642075,52153
case742075,46528
case842075,45000
case942075,48472
case1042075,50000

But Qliksense doesn't recognize the format as Excel date series . So the Line chart looks like this based on Date 1.

How do I load the data so that Qliksense recognizes the date format?

Kind regards

Mads

2 Replies

Re: How to ensure date format in Qliksense

Use below in script

TimeStamp(DateField) as DateField

Not applicable

Re: How to ensure date format in Qliksense

Thanks - works perfect in script loader

Community Browser