topic Re: change 'No data to display' message in QlikView

change 'No data to display' message

Tue, 26 Nov 2013 12:06:31 GMT

Hi all,

I have a chart which calculates the next expression:

count ({<RT_REJECTED={'No'}>} SUBSCRIBER_KEY)

when the calculation equals 0, I have the No data to display message.

I tried to alter the message in the objects general tab in errors, with no success.

can you please assist?

Thanks,

Boris

salto — Tue, 26 Nov 2013 12:10:04 GMT

Hello,

In the chart's calculation condition (General tab) write this:

count ({<RT_REJECTED={'No'}>} SUBSCRIBER_KEY) >0

And then, click the error messages button below, customize the Calculation Condition error message as you wish it to be.

Hope this helps.

Fri, 23 Jan 2015 11:17:48 GMT

Hi Salto,

I'm looking into a similar solution, though I have two expressions.

Would it be possible to achieve the same using the Calculation Condition field, joining the following two expressions with AND or OR?

=if(GetSelectedCount(%Market)=1,sum([Actual Volume (HL) W+1])/MostRecentYear_TotalVol)

=if(GetSelectedCount(%Market)=1,sum([TotalGM_perSKU])/MostRecentYear_TotalGM)

Thanks for your help!

Mel