topic Re: Dimension step in Bar Chart in QlikView

Dimension step in Bar Chart

Mon, 10 Mar 2014 10:09:51 GMT

Hey guys,

I have a problem with my dimension step in my bar chart. The dimension I use is a MMM - YY dimension and the bars show the cost's of every month. I used in the dimension axis 'Continuous', but my dimension shows only the following months now:

JAN 13 JUL 13 JAN 14 JUL 14

The bar chart should show ever third month of a year. So what I want is:

JAN 13 APR 13 JUL 13 OKT 13 JAN 14 APR 14 JUL 14 OKT 14

If I wider the chart the scale of the dimension adjusts, but that's no option, because I haven't enough space.

Kind regards,

Patrick Klein

Re: Dimension step in Bar Chart

MK_QSL — Mon, 10 Mar 2014 10:15:17 GMT

Go to presentation tab and deselect the Suppress Zero Values

If this will not solve your problem, better if you upload sample file along with your requirements.

Re: Dimension step in Bar Chart

sunilkumarqv — Mon, 10 Mar 2014 10:22:23 GMT

Follow the steps

1.Go to chart Properties

2.Dimesion tab.

3. below you can see supress when value is null check it

Apply and ok

make sure you dimension Axis should uncheck Continuous

You will get what you reqiured

Re: Dimension step in Bar Chart

Gysbert_Wassenaar — Mon, 10 Mar 2014 10:28:51 GMT

It sounds like your MMM-YY dimension is a date field. You can try using a static step of 91 (days).

Or you can try creating a new field where each month has a numeric value that increases by one for each next month. Something like dual( date(monthstart(MyDate),'MMM YY'), autonumber(monthstart(MyDate))) as ReportMonthYear. Then use ReportMonthYear as dimension and set the static step value to 3.