topic Change 'no data to display' error message if two expressions in QlikView

Change 'no data to display' error message if two expressions

Fri, 23 Jan 2015 11:20:26 GMT

Hello,

I understand the 'No data to display' error message can be changed by entering a chart expression into the 'Calculation Condition' field on a chart's General tab and then amending the error message associated with 'Calculation condition unfilled'.

My chart uses two expressions. Would it be possible to achieve this by joining the two expressions, possibly 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

Re: Change 'no data to display' error message if two expressions

Gysbert_Wassenaar — Fri, 23 Jan 2015 11:45:25 GMT

=(sum(aggr( ...expression1 ..., ChartDimA, ChartDimB, ..., ChartDimX))) OR (sum(aggr( ...expression2 ..., ChartDimA, ChartDimB, ..., ChartDimX)))

Re: Change 'no data to display' error message if two expressions

datanibbler — Fri, 23 Jan 2015 11:48:59 GMT

Hi,

ah - yes, then I know. I have looked just now and not found the "No data" one, but there is a button "error messages" on the "General" tab of the dialog of the object in question. If you go the way via the calculation condition, that one ("calculation condition not fulfilled") is in the list all right.

Best regards,

DataNibbler

Re: Change 'no data to display' error message if two expressions

Fri, 23 Jan 2015 11:52:26 GMT

Hi Gysbert,

Thanks very much for this.

I've tried the following (2 expressions, 1 dimension) but with no success yet.

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

, Dual([SKU Description],%SKU))))

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

, Dual([SKU Description],%SKU))))

Any further suggestions?

Thanks,

Mel

Re: Change 'no data to display' error message if two expressions

Gysbert_Wassenaar — Fri, 23 Jan 2015 12:38:38 GMT

Maybe the attached example helps. If not, try posting a qlikview document that demonstrates the problem.