topic Re: Display Axes even if there is no data in QlikView

Display Axes even if there is no data

Thu, 23 May 2013 16:48:39 GMT

Hi All

I need a little help. I have some transaction data which has a date component:

Jan 2013 - 20 units

Feb 2013 - 50 units

Mar 2013 - 60 units

Apr 2013 - 15 units

and so on

When i have this in a chart it all works fine, but i have a situation where I would like to display the whole year on the x-axis even though there is no data yet for May to Dec 2013. Is there a way to get the x-axis to show all the months regardless of having data or not?

Thanks

Re: Display Axes even if there is no data

shree909 — Thu, 23 May 2013 16:55:34 GMT

Hi try to create an inline table

[Calendar]:

LOAD * INLINE [

Month_ID, Month Year, Quarter

1, Jan 2013,Q1

2, Feb 2013, Q1

3, Mar 2013, Q1

4, Ap 2013, Q2

5, May 2013, Q2

6, Jun 2013, Q2

7, Jul 2013, Q3

8, Aug 2013, Q3

9, Sep 2013, Q3

10, Oct2013, Q4

11, Nov 2013, Q4

12, Dec2013, Q4

];

then load ur table

join (Calendar)

load * from

...

then use the monthyear as the dimension on the x-axis.

Thanks

Re: Display Axes even if there is no data

Tue, 28 May 2013 11:31:15 GMT

Thanks for the response. I already have a table like this which i use for the x-axis, but it only shows the months that have data, I need all the months to show.

Regards

Re: Display Axes even if there is no data

er_mohit — Tue, 28 May 2013 11:46:16 GMT

I think if you are using Chart then go to presentation tab and uncheck Suppress Zero values and Check on Zero on bars

or if you are using pivot or straight table then only uncheck the suppress zero value

hope it helps

Re: Display Axes even if there is no data

Tue, 28 May 2013 12:20:38 GMT

Brilliant thanks a mil.

Cheers