Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Harrisonpeg7
Contributor II
Contributor II

Line chart in Qlik Sense. Multiple X axis vaules only wanted to show 10/40

Hello! I am wanting to develop a line chart showing seafood availability in the US from 1970-2015. Currently the X axis is showing all the year values and there respected value. I would like to keep all of the values present in my table but only want to display the years in increment of 5ys (1970,1975,1980,etc.) Any advice on how to achieve this?

Labels (2)
1 Solution

Accepted Solutions
mahaveerbiraj
Creator II
Creator II

Hi 

Use dimension like below ..

If( mod(year,5 )=0, year)   use this in chart demension 

Please informe me if you are not clear

View solution in original post

3 Replies
Rohan
Specialist
Specialist

Hello,

I think The Class Function is something that you might wanna look up for this.

Using this function, you can divide your years into classes/ groups of 5 years each & then call this field in your graph.

Check this Link :

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...

 

 

mahaveerbiraj
Creator II
Creator II

Hi 

Use dimension like below ..

If( mod(year,5 )=0, year)   use this in chart demension 

Please informe me if you are not clear

Harrisonpeg7
Contributor II
Contributor II
Author

Thank you so much, very helpful. Easy to input and gave me the desired results!