Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sevvalk
Creator
Creator

I want to show the year and month together.

I want to see month and year together as dimensions in the column chart. For example; May 2023 January 2024 

Labels (4)
1 Solution

Accepted Solutions
paulcalvet
Partner - Specialist
Partner - Specialist

So you can do it also in the dimensions 

[Year] & ' ' & [Month]

View solution in original post

4 Replies
Cascader
Creator
Creator

try use expression :

Load Month(TempDate) & ' ' & year(TempDate) as MonthYear

from table;

 

:: TempDate is you date column you want to show as Month Year

 

sevvalk
Creator
Creator
Author

I didn't learn writing script. I want to do this in dimension settings for now.

paulcalvet
Partner - Specialist
Partner - Specialist

So you can do it also in the dimensions 

[Year] & ' ' & [Month]

sevvalk
Creator
Creator
Author

Thank you i did it. It works but When I set the sorting to "sort by month" it appeared incorrect. Is there any way to fix this?