topic Chart No Data to Display in QlikView

Chart No Data to Display

Sat, 03 Dec 2011 04:23:31 GMT

In the attached application I have a chart and when I select July it has no sales so the chart shows "No Data to Display" is there a way I can get the chart to show zero versus saying "No Data to Display".

Re: Chart No Data to Display

Sokkorn — Sat, 03 Dec 2011 04:55:08 GMT

Hi sbp,

It sound like customize message <No Data to Display>. Maybe I'm not get your point, but let try this

Right Click on Bar Chart ==> Properties ==> Select General Tab

1. Calculation Condition : IF(SUM(Sales)=0,0,1)

2. Click on button <Error Messages> ==> Custom Message and paste =IF(SUM(Sales)=0,'Value is 0')

Check in attached file also.

Do let me know.

Regards,

Sokkorn Cheav

Re: Chart No Data to Display

Sat, 03 Dec 2011 05:11:28 GMT

Thank you for your help.