Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

saurabh_pandit
Contributor

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
Employee

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

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.

3 Replies
Employee
Employee

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

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

Employee
Employee

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

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.

saurabh_pandit
Contributor

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

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