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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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