Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I could not hide NONE products ROWS in ABC analysis. in attached file made by John Whiperspoon. I tried dimension set but I could not do.
Well, I thought all it would take is setting up the [Accumulated Sales] column so that it was null when ABC was null without referring to the ABC column. There might be an easier way, but this seems to work:
if(rangesum(sum(MonthlySalesNetValue),above([Accumulated Sales]))
<= (A_Perc + B_Perc + C_Perc) * Sum(Total MonthlySalesNetValue)
and (rowno()=1 or above([Accumulated Sales]))
,rangesum(sum(MonthlySalesNetValue),above([Accumulated Sales])))
However, even when that is the ONLY expression in the chart, and we're suppressing nulls, the null rows do not suppress. I honestly don't know why.
Anyway, if they DID suppress, then all the other expressions could just take this form to make them suppress as well.
if(len(ABC),Expression)
Maybe it's a starting point. I'm probably missing something obvious about why the rows are suppressing, so we could be just one simple step from an answer.
Well, I thought all it would take is setting up the [Accumulated Sales] column so that it was null when ABC was null without referring to the ABC column. There might be an easier way, but this seems to work:
if(rangesum(sum(MonthlySalesNetValue),above([Accumulated Sales]))
<= (A_Perc + B_Perc + C_Perc) * Sum(Total MonthlySalesNetValue)
and (rowno()=1 or above([Accumulated Sales]))
,rangesum(sum(MonthlySalesNetValue),above([Accumulated Sales])))
However, even when that is the ONLY expression in the chart, and we're suppressing nulls, the null rows do not suppress. I honestly don't know why.
Anyway, if they DID suppress, then all the other expressions could just take this form to make them suppress as well.
if(len(ABC),Expression)
Maybe it's a starting point. I'm probably missing something obvious about why the rows are suppressing, so we could be just one simple step from an answer.
Hi John,
if I got the issue correctly, that's because (the Help file states about above() function):
Suppression of zero values is automatically disabled when these functions are used.
swuehl wrote:
Hi John,
if I got the issue correctly, that's because (the Help file states about above() function):
Suppression of zero values is automatically disabled when these functions are used.
Doh! Foiled by a technicality! I figured I was missing something simple.
John really thank you
You are one of to major reason that we love qlikview in our company