Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have QV model which has the following fields of Dates:
Day(VWDATE) as Day,
Date(floor(VWDATE)) as Date,
Date((floor(VWDATE)), 'DD/MM/YYYY') AS DateField
So when the model is loaded and I present each of the files in the list boxes I see that only Day field is sorted properly, whether Date sorted in descending order and DateField is not sorted at all.
Please see print screen attached,
I have to say that this phenomenon is new to me as in all models all Dates fields appear in ascending order without any manipulation from my side.
Please help.
Have you tried to enable a numeric sorting for this field?
- Marcus
Hi Marcus,
I tried to do :
Load * resident Fact order by Date asc;
It ran successfully , but without impact on sorting.
This is very strange, agree with you.
Could you post your sample qvw that demonstrates the issue?
Normally it should work with your method in both order per load-order and in a numeric-order then date() creates a dual-field even if the formattings is different to the default-format. But you could do it manually, too with:
dual(Date(floor(VWDATE), 'DD/MM/YYYY'), num(floor(VWDATE))) AS DateField
- Marcus