Discussion Board for collaboration on QlikView Layout & Visualizations.
Thanks Manish but it didn't work, it gave me even weirder results
Provide sample data.... please
Here's is the sample file
Change in script as below
date([Report Date],'MMM-DD-YYYY') as [Report Date],
and try again..
can you see the file ...
It is still not sorted correctly
The only change is -dd- by -DD-?
I did it but nothing changed....
if you add the year?
That's not the approach I want to overlap both years in 1 chart
I ran in to the same problem. I used Date(MonthStart(DateField), 'MMM-YYYY') to resolve my issue.