Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Bar Chart with Static X Axis (Months)

I have a table of data

SalesGuyDateSales
Person A1/1/2012

59

Person B1/2/201232
Person C2/1/2012423
Person A3/1/2012234

etc

I have a bar chart which shows the total sales for each month, with Month(Date) as the Dimension, and Sum(Sales) as an expression. It looks good!

But I want this chart to change when i click a ListBox of my SalesGuys, so it shows the clicked persons sales. Problem is, if SalesGuy A doesnt sell anything in March, the months will redraw as JFAMJJASOND, when I want JFMAMJJASOND and 0 for March. Its not obvious that the month has been omitted.

Hoe can I fix this, to force all months to be shown?

I have tried "Show All Values" and Surpressing nulls etc with no luck.

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Bar Chart with Static X Axis (Months)

I fixed it, perhaps it was a basic question.

I had to add Month(Date) as OffMonth to the script. Using that as my dimension, as opposed to Month (Date) works fine.

5 Replies
Not applicable

Bar Chart with Static X Axis (Months)

Try Unchecking "Suppress Zero-Values" under Presentation tab. Thats the only other thing I can think of.

Cheers

Not applicable

Re: Bar Chart with Static X Axis (Months)

Hi,

See attached, is this what you are looking for ?

In addition to what Sandeep recommends you also need to check "Show all values" check box for the dimension.

Best Regards,

MVP & Luminary
MVP & Luminary

Bar Chart with Static X Axis (Months)

Hi,

Unchecking "Suppress Zero-Values" in Presentation tab works perfect.

Regards,

Jagan.

Not applicable

Bar Chart with Static X Axis (Months)

I fixed it, perhaps it was a basic question.

I had to add Month(Date) as OffMonth to the script. Using that as my dimension, as opposed to Month (Date) works fine.

Not applicable

Re: Bar Chart with Static X Axis (Months)

Hello, I know this is a older post, but I have a Question.

When I try to use a average trend line in your archive, this is the result:3-19-2013 9-36-50 AM.png

Why this happens?, the total result is divided by 4 and not by 3 (January, February, March).

Is there a way that takes only the number of values ​​that really exist?.