Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sumitk
Partner - Creator
Partner - Creator

Display Message at the place of default message

Hi All,

I am trying to create a pie chart, when the value is coming zero during the selection it is showing a message "The chart is not displayed because it contains only negative or zero value" as shown in below image

WhatsApp Image 2024-05-31 at 3.22.22 PM.jpeg

I want to populate any custom message at the place of default message, Is it possible if Yes please let me know the steps.

Thanks in advance

 

Labels (5)
4 Replies
mpc
Partner Ambassador
Partner Ambassador

Hi, 

Maybe this trick: 

In the chart properties, in Data Handling Section, Calculation Condition, using expression =RowNo()>0 and then in Message, enter the desired one 

Kind regards

From Next Decision and mpc with love
sumitk
Partner - Creator
Partner - Creator
Author

Hi Thanks for your reply It doesn't work 

mpc
Partner Ambassador
Partner Ambassador

Then, maybe

If A my measure (here in Master Item), then in the same menu and input box: [A]>=0 and a display message ? 

mpc_0-1717404306793.pngmpc_1-1717404414294.png

 

 

From Next Decision and mpc with love
Or
MVP
MVP

Expounding on @mpc 's suggestion, you could use a condition along the lines of:

RangeMax(Aggr(YourExpressionHere,YourDimensionHere))>0