Supress Zero Values Problem

[AbhijitBansode]

I have a basic requiremnt of showing values in pivot chart when expression returns 0.

E.g. If Expression of pivot table is Sum(Amnt) and for certain selection this return 0. then QlikView will diaplay the message

'No data To Display'. But  my requiremnt is to show the data in pivot table with 0 as expression value.

Please find attched excel sheet for the details of the problem. also atteched is the sample application in which i'm trying to get the same.

[stevedark]

Hi there, you should be able to do this with set analysis on the expression:

Sum({<Year=>}Amnt)

That tells QlikView to ignore the year selection when calculating the value.  You can add other fields as required by comma separating them, eg:

Sum({<Year=,Month=,Date=>}Amnt)

Hope that helps.

Steve