Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Type | Month |
a | August |
b | September |
c | September |
d | September |
e | September |
f | September |
g | October |
h | September |
Can someone help me on how to sort the month?
Qlik view sort show August,October,September.
I want it to sort like August,September,October.
Please help me. Thank you.
QV does not know that the field 'Month' is actually a date field. A short (but dirty) solution would be an expression in a listbox: =date#(Month,'MMMM')
Hi,
For Sorting the month names...first save this file in a QVD then use this QVD and apply Dual Function on Month Field.
Hope this will help you.
Regards
Suresh Rawat
Hi,
In script try like this
LOAD
*,
Date(Date#(Month, 'MMMM'), 'MMMM') AS MonthSort
FROM DataSource;
Now use this dimension in chart and select Numeric in Sort tab.
Regards,
Jagan.
Hi,
have a look at attached application.
Regards
ASHFAQ