Discussion board where members can get started with Qlik Sense.
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.
Go to 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.
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.
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.