Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LeonardoLuc
Contributor
Contributor

Group dimension value

Hello everybody,

i need to group the dimension of this line chart in decades: instead of having years i want a range of 10 years for each measure (for example 1910-1920, 1920-1930). 

LeonardoLuc_0-1611683841740.png

The dataset is about movies and i want to count how many movies are released each decade

1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @LeonardoLuc !

Try this:

Class(Year_Dimension,10) 

or

Replace(Class(Year_Dimension,10),'<= x <','-')

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @LeonardoLuc !

Try this:

Class(Year_Dimension,10) 

or

Replace(Class(Year_Dimension,10),'<= x <','-')

Help users find answers! Don't forget to mark a solution that worked for you!
LeonardoLuc
Contributor
Contributor
Author

Oh it was easy, thank you so much!