topic Re: Statistics Box Shows all values as null and missing unless a selection is made in QlikView

Statistics Box Shows all values as null and missing unless a selection is made

qlikuser2021 — Fri, 07 May 2021 14:53:06 GMT

Statistics box shows null count and missing count for all rows when no selection is made. n/a for average, min, and max. I confirmed there are no null or missing values. How do I get it to show the totals for all rows when no selection is made. I want to display the average balance for all rows not just when a selection is made.

Re: Statistics Box Shows all values as null and missing unless a selection is made

rwunderlich — Fri, 07 May 2021 17:41:20 GMT

n/a is typically shown when there are only non-numeric values available. Add the "Numeric Count" function to your stats box.

-Rob

Re: Statistics Box Shows all values as null and missing unless a selection is made

qlikuser2021 — Fri, 07 May 2021 19:07:32 GMT

Numeric count, total count, and sum = 0. Average, min, and max = n/a when nothing is selected. If I select anything then they populate as expected. I was expecting it to have counts when nothing is selected as if everything was selected. Is there a way to get it to display statistics for all rows when nothing is selected?

Re: Statistics Box Shows all values as null and missing unless a selection is made

rwunderlich — Sat, 08 May 2021 14:51:21 GMT

If Numeric Count = 0 then that means there are no numbers to compute an Average, Min or Max against. In which case n/a makes sense. What I don't understand is why it changes when you make selections? Are you making selections directly against the field, like in a listbox?

-Rob

Re: Statistics Box Shows all values as null and missing unless a selection is made

qlikuser2021 — Sat, 08 May 2021 15:25:24 GMT

Yes. When I make selections in a list box the statistics calculate as expected. If I clear all the selections it shows Numeric count, total count, and sum = 0. Average, min, and max = n/a