topic Graph with month and value at 0 in QlikView

Graph with month and value at 0

yusenlogistics — Thu, 12 Mar 2015 16:19:02 GMT

Hello,

I have a problem with a graph in QV.

This graph present a quantiy by month for one fiscal year ( from April N to March N+1)

The problem is that sometimes there is no quantity for a month. In this case, the month doesn't appear in the graph.

for example : no dato for August and October

I have tried to selected the option "Show all the value" on the dimension but the problem is that Qlik View show all the different value of the dimension and lose the link with the filter FISCAL YEAR. The graph present all the month even if I selected just two month and the sorting of the month is not good because QV lose the link between the month and ths fiscal year as I can see in the Table I have created near the graph.

Do you have any idea for resolve my issue?

Thank you very much in advance for your help!

Re: Graph with month and value at 0

rubenmarin — Thu, 12 Mar 2015 16:20:33 GMT

Hi Stéphanie, in Presentation tab, uncheck 'Supress zero values'.

Hope this helps!

Re: Graph with month and value at 0

yusenlogistics — Thu, 12 Mar 2015 16:26:06 GMT

Hi Ruben!

Thank you for your reply!

I tried to uncheck 'Supress zero values' but this option doesn't resolve my issue because I want to have the value at 0 IF I selected the month with a value at 0...

Re: Graph with month and value at 0

rubenmarin — Thu, 12 Mar 2015 16:36:32 GMT

Hi Stéphanie, I made a very simple example, if I select Month '2', the chart shows the point at 0, isn't that what you want?

Re: Graph with month and value at 0

yusenlogistics — Thu, 12 Mar 2015 16:59:20 GMT

Hi,

Thanks for your help.

I have created an other table with month, Type and Qty and added two graph.

I realised the sum of the Quantity If the Type = "T1" with using set analysis

The result of my first graph is not good because I just want to have the month 2 and 3 as I have selected.

The result of the second graph is not what I want because I would like to have the value of the month 2 and the month 3.

Hope it's clearer 😉

Thank you very much!

Re: Graph with month and value at 0

rubenmarin — Fri, 13 Mar 2015 08:15:00 GMT

Hi, unchecking "show all values" and "supress zero values" this expression can work:

If(not IsNull(Month), sum({$<Type={"T1"}>} QTE))

I can't explain why it's working.

Re: Graph with month and value at 0

yusenlogistics — Fri, 13 Mar 2015 10:01:54 GMT

Hi,

Thank you very much!! I don't understand too why it's working but it's working!

I have tried to find a solution during a long time... Thank you very much for your help!

Stéphanie