Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
poojask123
Partner - Creator
Partner - Creator

"No data to display" message in pivot table

Hi,

I have generally observed that charts display a message " no data to display" when there is no data to be displayed in the chart against a selection.

But when it is for a pivot table or straight table, it just displays zero or the table collapses based on the settings on Suppress Zero values.

I have a requirement to show "no data to display" message in a pivot table.

Is it possible ?

Please help.

Thanks

Pooja

1 Solution

Accepted Solutions
avinashelite

Try like the attached app

View solution in original post

13 Replies
Anil_Babu_Samineni

Yes, It is possible by  help of enable the condition from general tab. Will you able to provide Data or application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sushil353
Master II
Master II

Hi,

go to General Tab of your chart property>Error Messages> Click on All expressions disable and there you can put your message to display.

HTH

sushil

poojask123
Partner - Creator
Partner - Creator
Author

Hi Sushil,

I tried this, did not help.

poojask123
Partner - Creator
Partner - Creator
Author

Adding a sample application. Here when i select UK, the table collapses. Instead want it to display "no data to display"

avinashelite

Try like the attached app

Kushal_Chawda

see this

poojask123
Partner - Creator
Partner - Creator
Author

Thanks it worked

poojask123
Partner - Creator
Partner - Creator
Author

Thanks it worked

poojask123
Partner - Creator
Partner - Creator
Author

Hi,

wat will be my calculation condition if i have negative numbers also as my value for sum(Population) ?

currently the condition is sum(population) >0,