Error when the Dimension gives measure values as zero (not negative).

[Anonymous]

Thanks Michael,

for #5 - English:

"The data set contains negative values being equal to zero or impossible to display in this graph"

I don't have negative values but zero values for some Dimension.

Is it possible to not get that Error when the Dimension gives measure values as zero (not negative).

Should we calculate the Dimension using if(...) condition to avoid the ones which will give zero.

Generally in Add-ons there is a way to Hide Zeros but its not there in Pie or Treemap.

Thanks,

Saurabh Pandit

[Michael_Tarallo]

Hello Saurabh, - I branched your discussion to a new thread. Let' see if we can get more eyes on this.

jpe‌ - my buddy here 🙂 might be able to assist if he has a min.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[JonnyPoole · Accepted solution]

I agree.  You can use a calculated dimension to to do this.

If your dimension is:  COUNTRY

and the measure is:   SALES

Change the dimension to:    if (  aggr(sum(SALES),COUNTRY) > 0 , COUNTRY)

... then ensure you select the checkbox to hide NULLs on the dimension.

You may also be able to do a dimension limit using the > 0 value as well.

[Anonymous]

Thanks jpe

Using aggr or Dimension limit is a great idea when we dont know which Dimension would give zero values!

When we know which Dimensions to ignore then we can directly use if(Dimension='A','B'...) or maybe pick(match())..

Quick Answer: We need to basically use Hide null property of Dimensions.

Cheers,

Saurabh Pandit