topic Re: Restrict number of shown values on x axis in QlikView

Restrict number of shown values on x axis

Wed, 11 Sep 2013 07:58:30 GMT

Hello,

If i have a line graph, with 20 dates. How can i do so it only shows every second date, or every third date?

Re: Restrict number of shown values on x axis

Andrea_Ghirardello — Wed, 11 Sep 2013 08:10:46 GMT

If you need to achieve a result like "show only the third country value", you can:

- add a calculated dimension using the following formula : =if(Country=FieldValue('Country',3),Country,Null)

- enable the "Suppress When Value Is Null" for this expression

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 08:12:13 GMT

I want all values, i just dont want to show all the dates....

Like the function Continuous in the Axes tab. But Continuous shows numeric values. Not dates

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 08:16:37 GMT

Hi,

Go to the properties->Dimension Limits You can specify the limitation for your date shown in dimension

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 08:18:56 GMT

Based on what? Cause i dont want to see the smallest only, neither the largest only. and neither only the first 10.

Re: Restrict number of shown values on x axis

Andrea_Ghirardello — Wed, 11 Sep 2013 08:22:31 GMT

Ok...so try this

- add a calculated dimension using the following formula : =if(Country=FieldValue('Country',3),Country,'')

- DO NOT enable the "Suppress When Value Is Null" for this expression

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 08:25:37 GMT

=if(Date_Clean=FieldValue('Date_Clean',3),Date_Clean,'')

not working . Only gives me one value

Re: Restrict number of shown values on x axis

Andrea_Ghirardello — Wed, 11 Sep 2013 08:30:05 GMT

Sorry if I didn't understand your post ("I want all values, i just dont want to show all the dates....")... I understood that you would see all chart rows but only a date for date dimension...

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 08:33:13 GMT

Let me specify.

I have a line graph with revenue the past 20 days.

i want a line graph with revenue the past 20 days, but where only every second date is shown. But the value for the hidden date is ofc shown.

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 09:07:43 GMT

Hi Thomas,

Within the Axes tab you can check continuous.

Add static step 2 if you'd like to show every other date

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 09:09:18 GMT

yes, but it would show me dates in numeric way. So it makes it to numbers like 40152

Re: Restrict number of shown values on x axis

Andrea_Ghirardello — Wed, 11 Sep 2013 09:17:53 GMT

I tried and it shows me data in date format.

Create a custom field in script populated only with data you need (e.g. Step_2_Date) and use it in your chart.

I have no other ideas.

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 09:20:42 GMT

it did? At my place it change them from dates to numeric numbers.

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 09:33:21 GMT

Ahh - Continuous creates an "expression" you can change under number, so you can make it dates. Then it works.

Re: Restrict number of shown values on x axis

Wed, 11 Sep 2013 10:01:20 GMT

In axes tab use continuous in x axis and static step=2 and in number tab make the format as date

Re: Restrict number of shown values on x axis

Prabhu — Tue, 02 Apr 2019 12:25:16 GMT

How can we show only unique values for country? (No duplicates)

Re: Restrict number of shown values on x axis

Prabhu — Tue, 02 Apr 2019 12:29:23 GMT

HI Andrea,
How to show only unique values of country?
@ Andrea_Ghirardello