How to show dates in ascending order ??

[nikhilgarg]

HEy,

I want to show my values of Day-Month-Year as on X-axis in ascending order. But my dates are coming in descending order.

How to do it ??

Please help.

Thanks.

[arulsettu]

hi

try in properties -> sort -> your field -> select ascending

[nikhilgarg]

HEy,

It does not work.

[senpradip007]

Can you share sample qvw?

[nikhilgarg]

Hey,

Please find the attached sample.

Thanks

[PrashantSangle]

Hi,

Instead of using calculated dimension use Date Field as your dimension.

Since you are calculating Day,Month and Year from Date field.

Take Date Field in while loading and add it as dimension

If you want your Date field in DD-MMM-YYYY format then

you can format in while loading like Date(Date,'DD-MMM-YYYY') as NewDate

and take that newDate as your dimension then go to sort property-> Numeric value->descending

Regards,

[pandiarajan]

Sort - > SELECT THE NUMERIC  Value -> ASCENDING

[manuelreimitz]

or sort by expression in worst case!

num(Datefield)

[tresesco]

Sort by expression (Ascending):

=Date#(Day&Month&Year, 'DDMMMYYYY')

However, it is always recommended to create a proper date field in the script to avoid such issues and enhance your app quality.

PFA

[sunilkumarqv]

@Check attached