topic Re: Problem with chart dimensions in QlikView

Problem with chart dimensions

Mon, 04 Mar 2013 12:33:28 GMT

Hi,

I have a bar chart that is showing a measure, trended over month and year dimensions. There is a dummy "=1" dimension on the chart also used to prevent the months being stacked on the chart.

I want all of the chart values to be displayed at all times, even if the user adds a filter that will take a month value to zero i.e. all years and months are shown even if there aren't any values for them in the selection.

To achieve this, I have ticked the "Show All Values" option on the "Year" and "Month" dimensions and also unticked the "suppress zero values" on the Presentation tab of the chart properties.

So far so good - everything works how I want it... however an extra null (shown by "-" symbol) value for the year dimension has appeared from somewhere that I cannot remove.

I have created attached an application to demonstrate the problem. Can anyone assist me with this problem?

Thanks,

Mike

Re: Problem with chart dimensions

Mon, 04 Mar 2013 12:48:57 GMT

Check Surpress When value is Null

Re: Problem with chart dimensions

Mon, 04 Mar 2013 12:49:43 GMT

Re: Problem with chart dimensions

Mon, 04 Mar 2013 13:40:02 GMT

Thanks yaseen but I have tried this already. When you do this and then filter on "snickers" in my example, the month of March disappears. This is because there are no sales for snicker in march, but I would still like this value to appear on the chart.

Re: Problem with chart dimensions

Gysbert_Wassenaar — Mon, 04 Mar 2013 13:56:03 GMT

If you're using QV11 you can use alternate states. See attached qvw.

Re: Problem with chart dimensions

Mon, 04 Mar 2013 14:21:11 GMT

I am indeed using v11. Never used Alternate States before.

Have applied your solution to my master application and its working perfectly.

Many thanks for your help.