Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Gianluigi
Contributor
Contributor

Calendar dimensions in QlikSense

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

Gianluigi_0-1637680138295.png

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

Gianluigi_1-1637680316073.png

 

2 Replies
Or
MVP
MVP

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.

MarcoWedel

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:

MarcoWedel_0-1637697430936.png

thanks

Marco