yes thats what i did.
I am sorting the month dimension with the formular by DATEID (YYYYMMDDHH).
No idea why that is not working.
I think it has something to do with the fact that my fact table provides values aggregated to the hour.
The fact table and the dimension table of the time are connected.
However the sorting should still be fine, i just dont get it :/
i think too that this might be the real reason since sorting works if i display values by the hour.
Your method is unfortunately not working either - i also tried this before.
My time dimension format has a numeric value like this YYYYMMDDHH but i also have another field where i
just output to YYYYMM. Using this value for sorting doesnt work either.
I pretty frustrated since this should work ion my opinion :/
The "YYYYMMDDHH" format is not the standard one... It looks like a string value.
Try to convert it to numeric (the best option is to create another field DATEID_NUM and use it for sorting only).
You might need to use MakeDate(YYYY [ , MM [ , DD ] ]) and MakeTime(hh [ , mm [ , ss ] ]) functions (extracting corresponding values from DATEID field, and concatenate these values into DATEID_NUM field)...
Using NUM values for sorting should work fine in your case.
Ok, i found 'a' solution - however i have to say that it doesnt make sense and for me it is a bug in Qlik unless
somebody can give me another explanation.
I have an integer field [MONAT_SORT] in the format YYYYMM.
Using this field for sorting doesnt work when the data is being grouped down to the hour, so (YYYYMMDDHH).
If i do another field for sorting using this function the sorting works perfectly:
Maybe somebody can enlighten me ...