topic Re: How can I show only every 10th value on x axis? in QlikView

How can I show only every 10th value on x axis?

bumin — Sun, 19 Jul 2015 09:42:36 GMT

Hi,

I have big chart with 600 values on the x axis.

is is possible to show only every 10th value, so I will have only 60 values on th x axis als legend

thanks

Bumin

Re: How can I show only every 10th value on x axis?

maxgro — Sun, 19 Jul 2015 09:59:48 GMT

did you already try to uncheck stagger labels in axis tab? you get few values on x-axis (maybe not only every 10th)

Re: How can I show only every 10th value on x axis?

bumin — Sun, 19 Jul 2015 10:06:47 GMT

Hi Massimo,

I have uncheked "stagger labels". But still I have the same number of values on the x axis legend

Re: How can I show only every 10th value on x axis?

marcus_sommer — Sun, 19 Jul 2015 10:14:51 GMT

Within the tab presentation (top right) is an option to limit the count of x-axis values with a possibility to use an scrollbar.

- Marcus

Re: How can I show only every 10th value on x axis?

bumin — Sun, 19 Jul 2015 10:19:52 GMT

but it want to see all values on one view.

I just want to show less legend on the x axis

Re: How can I show only every 10th value on x axis?

maxgro — Sun, 19 Jul 2015 10:24:28 GMT

this is what I get with unchecked/checked stagger

Re: How can I show only every 10th value on x axis?

bumin — Sun, 19 Jul 2015 10:32:03 GMT

yes you are rigth. It shows less

Re: How can I show only every 10th value on x axis?

Anonymous — Sun, 19 Jul 2015 10:55:32 GMT

You could try this :

Create an additional expression with an IF statement to only display the Dim values you want
- = if ( Dim = 'B' , Dim , '' )
- This will only show where Dim is B, you'll need to sort your own logic here for every 10th value
For this expression tick Text on Axis and untick all other Display Options
For the Dimension untick Show Legend
You may need to use <Ctrl><Shift> to move / resize your Chart sub objects.

Re: How can I show only every 10th value on x axis?

bumin — Sun, 19 Jul 2015 11:28:22 GMT

very nice solution , thanks

Re: How can I show only every 10th value on x axis?

Anonymous — Sun, 19 Jul 2015 13:46:36 GMT

I have found it useful, when I wish display data at daily granularity, but label it monthly.

Also by using the GetPossibleCount() function on your dimension you can get it to flex how many labels are displayed for the number of data points.

Re: How can I show only every 10th value on x axis?

Mon, 20 Jul 2015 08:50:26 GMT

I got by using simple function, Adding calaculate dimension =If(Mod(S.No,10)=0,S.No).

After Using =If(Mod(S.No,10)=0,S.No)

regards,

kalyan.

Re: How can I show only every 10th value on x axis?

Mon, 20 Jul 2015 08:56:06 GMT

Hi Bumin‌,

Just adding calculate dimension if(mod(dimension,10)=0,dimension).

regards,

kalyan.

Re: How can I show only every 10th value on x axis?

Anonymous — Mon, 12 Dec 2016 13:33:47 GMT

I use the show values associated with the expression. Try:
=if(mod('$(vMaxDateID)' - Date_ID,10),1,0)

where vMaxDateID is variable and your max Date_ID

See pic: