Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Harrisonpeg7
New 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 (3)
1 Solution

Accepted Solutions
mahaveerbiraj
Contributor II

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

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
New Contributor III

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

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
Contributor II

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

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

Harrisonpeg7
New Contributor II

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

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