# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator

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

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

1 Solution

Accepted Solutions
Employee

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

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.

3 Replies
Employee

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.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Employee

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

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.

Creator
Author

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

Tags
Community Browser