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

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

Harrisonpeg7 — Sat, 16 Nov 2024 20:10:09 GMT

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?

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

Rohan — Fri, 30 Aug 2019 05:18:42 GMT

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/ConditionalFunctions/class.htm

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

mahaveerbiraj — Sat, 31 Aug 2019 20:14:07 GMT

Use dimension like below ..

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

Please informe me if you are not clear

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

Harrisonpeg7 — Tue, 03 Sep 2019 11:33:11 GMT

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