Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
puneetagarwal
Partner - Creator II
Partner - Creator II

How to change the message instead of no data to display

Hi,

I have a Bar chart and when I am clicking on any selection based on selection the data is changing and when there is no relevant data it is showing 'No Data to Display'. I  want to show as 'No Transactions' instead of 'No Data to Display'.

Could anyone help me how to set this as I am not aware of this earlier.

Regards,

Puneet Agarwal

6 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

barchart.png

==> error message ==> choose the first one ==> add your customized message

puneetagarwal
Partner - Creator II
Partner - Creator II
Author

Hi,


Still it is showing the same default Message 'No Data to Display'


P.S: I've added calculated condition as well but its not working still.

Thanks,

Puneet

YoussefBelloum
Champion
Champion

so try to go to the sixth one and add your custom message (the sixth one is related to the calculated condition)

puneetagarwal
Partner - Creator II
Partner - Creator II
Author

Hi ,

Tried that one but it works only when the calculation is set as count(employee)=0 (It displays the custom message)

Eg: If we set count(employee)>0 it  displays default message.

devarasu07
Master II
Master II

Hi,

try like this

=if(GetSelectedCount(Employee)>0 and GetSelectedCount(Year)>0,1,0)

Capture.JPG

puneetagarwal
Partner - Creator II
Partner - Creator II
Author

Hi Devarasu,

Thanks, it helps upto some extent. But the problem is the chart is not showing any data even if we select the year where the data was there.

Eg: If there was no data for 2017- it shows my custom message but for 2018( we have data) it populates the same message instead of showing the data.

Regards,

Puneet Agarwal