topic Re: "No data to display" message in pivot table in QlikView

"No data to display" message in pivot table

poojask123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: "No data to display" message in pivot table

Anil_Babu_Samineni — Mon, 10 Jul 2017 06:30:38 GMT

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

Re: "No data to display" message in pivot table

sushil353 — Mon, 10 Jul 2017 06:31:35 GMT

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

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 06:41:10 GMT

Hi Sushil,

I tried this, did not help.

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 06:41:50 GMT

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

Re: "No data to display" message in pivot table

avinashelite — Mon, 10 Jul 2017 06:53:53 GMT

Try like the attached app

Re: "No data to display" message in pivot table

Kushal_Chawda — Mon, 10 Jul 2017 06:55:17 GMT

see this

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 07:02:31 GMT

Thanks it worked

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 07:02:43 GMT

Thanks it worked

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 07:52:12 GMT

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,

Re: "No data to display" message in pivot table

avinashelite — Mon, 10 Jul 2017 08:53:27 GMT

It will show the same error but how the population can be -ve ??

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 09:22:05 GMT

population is just an example i have taken here the actual field i am using is an amount field which can have 0, +ve,-ve and null values.

I want the chart to display whenever there is +ve n-ve data and show me the error message only when the value in field is either null or 0.

Re: "No data to display" message in pivot table

avinashelite — Mon, 10 Jul 2017 09:33:02 GMT

then change the condition like this

if(sum(population) =0 or sum(population) ='',0,1)

Re: "No data to display" message in pivot table

poojask123 — Mon, 10 Jul 2017 10:16:31 GMT

Yea i wrote that n it seems to be working for now

Thanks