topic Re: Calendar dimensions in QlikSense in App Development

Calendar dimensions in QlikSense

Gianluigi — Tue, 23 Nov 2021 15:14:38 GMT

Hi to everyone,
i have some problems on defining calendar dimensions.

I need to define "month", "Year", "YearMonth".
This scrip works but i'm not able to sort the dimension chronologically on the graph

Re: Calendar dimensions in QlikSense

Or — Tue, 23 Nov 2021 15:23:10 GMT

Your YearMonth field seems a bit strange. Are you able to use MonthName(DataOrdine) instead? If you need this exact format rather than the default MonthName() format, you can use Date(MonthName(DataOrdine),'MMM-YYYY') instead.

Re: Calendar dimensions in QlikSense

MarcoWedel — Tue, 23 Nov 2021 20:04:18 GMT

can you please post some values of DataOrdine loaded as Num(DataOrdine) and Text(DataOrdine) so we can see what your original data looks like and also explain your expected result of the YearMonth field?

These nested formatting and interpretation functions most likely do not work like you expect:

thanks

Marco