topic Show territories sales sum with zero Sales in QlikView

Show territories sales sum with zero Sales

JustinDallas — Mon, 05 Jan 2015 20:39:49 GMT

Hello Everyone,

So I have a chart that I am using to show the NetSales by Territory but doesn't show territories with no sales in a given set.

When I do a simple sum, I get this.

However, they want Month to date, meaning I need to use Set Analysis and restrict to the current year (=SUM({$<Year = {'$(vYear_Current)'}>} NetSalesDOM)) I get an empty chart because there aren't any sales for the current year of 2015. How do I make the set return a zero in the place of a null set sum?

Any help in this matter is greatly appreciated

Re: Show territories sales sum with zero Sales

german_avanzato — Mon, 05 Jan 2015 20:54:47 GMT

If I understand correctly, maybe you should try "Show all values" in the dimension options, and in the "Presentation" tab, change the Null and Missing Simbol to 0

Re: Show territories sales sum with zero Sales

rwunderlich — Mon, 05 Jan 2015 20:55:27 GMT

Uncheck "Suppress Zero Values" on the Presentation pane.

-Rob

Re: Show territories sales sum with zero Sales

JustinDallas — Mon, 05 Jan 2015 21:02:29 GMT

Thanks German, but no dice. It still doesn't show me the Territories. Also, setting the "Show All Values" to true doesn't work either

Re: Show territories sales sum with zero Sales

JustinDallas — Mon, 05 Jan 2015 21:31:53 GMT

Never mind, apparently I was clicking "OK" and not "APPLY" after de-selecting the "Suppress Zero-Values". German was right.