Qlik Community

New to Qlik Sense

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saurabh_pandit
Creator
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
JonnyPoole
Employee
Employee

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.

View solution in original post

3 Replies
Michael_Tarallo
Employee
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.

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

Regards,
Mike Tarallo
Qlik
JonnyPoole
Employee
Employee

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.

View solution in original post

saurabh_pandit
Creator
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