Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

oscarmqz
Contributor III

Re: Date sort order in line chart

Thanks Manish but it didn't work, it gave me even weirder resultsCapture.JPG.jpg

Re: Date sort order in line chart

Provide sample data.... please

oscarmqz
Contributor III

Re: Date sort order in line chart

Here's is the sample file

Re: Date sort order in line chart

Change in script as below

  date([Report Date],'MMM-DD-YYYY') as [Report Date],

and try again..

ecolomer
Honored Contributor II

Re: Re: Date sort order in line chart

can you see the file ...

Highlighted
oscarmqz
Contributor III

Re: Date sort order in line chart

Hi Enrique,

     It is still not sorted correctly

oscarmqz
Contributor III

Re: Date sort order in line chart

The only change is -dd- by -DD-?

I did it but nothing changed....

ecolomer
Honored Contributor II

Re: Re: Date sort order in line chart

if you add the year?

oscarmqz
Contributor III

Re: Date sort order in line chart

That's not the approach I want to overlap both years in 1 chart

travis_craven
New Contributor

Re: Date sort order in line chart

I ran in to the same problem. I used Date(MonthStart(DateField), 'MMM-YYYY')  to resolve my issue.

Community Browser