topic Re: Can I have zero values chart against selection with no data. in QlikView

Can I have zero values chart against selection with no data.

Thu, 23 May 2013 07:36:08 GMT

Hi everyone ,

I am facing a problem which I am explaining below, can anybody address this ?

I have 2 dimensions "Year" and "Product"

=====================

Year

=====================

2008

2009

2010

2011

=====================

Product

=====================

Product Year Sale

=====================

A 2010 1

A 2011 2

B 2010 3

B 2011 4

C 2010 5

C 2011 6

D 2010 7

D 2011 8

E 2010 9

E 2011 10

F 2010 11

F 2011 12

======================

Now the problem is when I select Year 2008 or 2009 then against these years there are no sales(no records) so chart does not display saying "No Data To display"

So my question is can I have a chart with zero values against these years ?

Re: Can I have zero values chart against selection with no data.

er_mohit — Thu, 23 May 2013 07:40:32 GMT

in presentation tab uncheck suppress zero value

hope it helps

Re: Can I have zero values chart against selection with no data.

Sokkorn — Thu, 23 May 2013 07:44:34 GMT

Hi,

Check this post may help you.

Regards,

Sokkorn

Re: Can I have zero values chart against selection with no data.

Thu, 23 May 2013 08:35:44 GMT

Hi Sokkorn ,

But in your case sum for July was calculated because there was a record of July but its sales was - so which caused sum as 0 , But in my case you can say July exists in Date table(Filter) but does not have any associated records in fact table. How can I do this in the following case. I am attaching sample files and what i want is when I select June, July then chart should show 2 bars but bar of July should have 0 value.

Re: Can I have zero values chart against selection with no data.

sushil353 — Thu, 23 May 2013 08:47:41 GMT

Please find the updated file

HTH

Sushil