topic List Box to Show Zero Qty in Water Cooler

List Box to Show Zero Qty

Wed, 16 May 2012 21:53:26 GMT

I have a simple list box using WeekYear (1-2012, 2-2012, etc) for the General Field and Sum(quantity) for the expression, which is the sum of the sales orders for that week. By default, I'm guessing, the the List Box shows only those weeks with greater than zero quantity in the window. I would like to show the zero qty, as well.

List Box to Show Zero Qty

Jason_Michaelides — Wed, 16 May 2012 22:04:07 GMT

One of the tabs (presentation?) has a checkbox for Suppress Zero Values. This is ticked by default - untick it.

Hope this helps,

Jason

Re: List Box to Show Zero Qty

Thu, 17 May 2012 13:11:53 GMT

I find no Suppress Zero Value checkbox in any of the List Box tabs?! JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 13:44:29 GMT

Sorry - I misread your original post! You are right - there is no option to do this in a list box. However, zeros should not be hidden either - are you sure there are actually WeekYear values presentin the data which have zero quantity?

Re: List Box to Show Zero Qty

Thu, 17 May 2012 13:47:20 GMT

Yes, in fact, if I scroll down into the shaded area of the list box, I see zero values in the very weeks that I’d like shown in the white area. JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 13:53:59 GMT

Oh hang on! Are you saying you want to make some selections that will push some WeekYear values into grey (i.e. not associated to current selections) but still want the Sum(Quantity) to show in the listbox?

Re: List Box to Show Zero Qty

Thu, 17 May 2012 13:57:33 GMT

Yes, they are associated with the WeekYear selection, but because they’re zero, they don’t show up in the white area, only in the grey. JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 14:02:23 GMT

That doesn't sound right. Can you post your app?

Re: List Box to Show Zero Qty

Thu, 17 May 2012 14:39:39 GMT

I’m not sure how to do that on the forum (I tried to attach it, but it’s too big). JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 15:14:06 GMT

Reduce the data by making some selections then File > Reduce Data. Then save and post.

Re: List Box to Show Zero Qty

Thu, 17 May 2012 15:41:32 GMT

Here’s what I think is a cut-down version. Number 10393-01 is selected, it should display, among other things, WeekYears with their associated sales quantity for that week. What I need it to do is have each WeekYear show up in the Sales Qty by WeekYear box, whether zero or not, if that makes sense (we actually need to see that no orders were made during that week). JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 16:06:45 GMT

I meant the qvw file.

Re: List Box to Show Zero Qty

Thu, 17 May 2012 16:41:00 GMT

Sorry, mis-selected the file. JPT

Re: List Box to Show Zero Qty

rwunderlich — Thu, 17 May 2012 17:08:49 GMT

Why do you want to show them in the white area instead of gray? There is nothing associated with those weeks, it would seem to be confusing to show them as white.

As an alternative you could make a straight table with all weeks.

-Rob

Re: List Box to Show Zero Qty

Thu, 17 May 2012 19:06:23 GMT

I want it to show all Week-Years with their associated sales quantity, whether zero amount or not. JPT

List Box to Show Zero Qty

Jason_Michaelides — Thu, 17 May 2012 20:26:20 GMT

What if a user selects January2012? Do you still want a list of all MonthYears? And if so, should the totals for all rows except Jan2012 be zero, or should the totals for all months completely ignore user selections? Either way, Rob's suggestion of a straight table is probably the best on for you. If you want all months shown always but the totals dependent upon user selections then just tick the Show All Values box in the dimension tab and untick the suppress zero values in the presentation tab. If you want the totals to completely ignore user selections then instead of Sum(Sales) use Sum({1} Sales).

Jason

Re: List Box to Show Zero Qty

Thu, 17 May 2012 20:43:42 GMT

I would expect the box to show only the WeekYears for January 2012, but all of them, whether zero or not. JPT

List Box to Show Zero Qty

Jason_Michaelides — Fri, 18 May 2012 09:05:54 GMT

What did you reduce the data on before posting? Is it possible to clear and unlock all selections, just select Year = 2012 (from the master calendar field, Year) and post again?

Re: List Box to Show Zero Qty

Fri, 18 May 2012 15:48:59 GMT

Thanks for your help. I realized that the I already have the information in one of my pivot tables. JPT