topic Re: Message inside a Chart in QlikView

Message inside a Chart

Anonymous — Wed, 27 Jul 2016 16:23:15 GMT

I can’t find in Chart Properties how I can change the text which appears in Chart in case the Chart is not calculated.

It does not belong to Error Message Setting.

Could you please have a look in the file attached?

Thank you in advance,

Larisa

Re: Message inside a Chart

maxgro — Wed, 27 Jul 2016 16:29:33 GMT

if I understand in genaral (1st one) tab

Re: Message inside a Chart

NickHoff — Wed, 27 Jul 2016 16:32:24 GMT

Under General you will have the calculated condition which you'd like to to occur before showing the data. So you set that first, then under Error Messages under calculation condition unfulfilled you'll add your condition similar to the following:

=IF((GetSelectedCount(@AdHocDim) = 0 AND GetSelectedCount(@AdHocPHIDim) = 0) AND GetSelectedCount(@AdHocMetric) = 0,

'Select a dimension(s) and metric(s) to create a report.',

IF((GetSelectedCount(@AdHocDim) > 0 OR GetSelectedCount(@AdHocPHIDim) > 0) AND GetSelectedCount(@AdHocMetric) = 0,

'Select a metric(s) to create a report.',

'Select a dimension(s) to create a report.'))

This is what I use for my calculated condition for this example:

(GetSelectedCount(@AdHocDim) > 0 OR GetSelectedCount(@AdHocPHIDim) > 0)

AND

GetSelectedCount(@AdHocMetric) > 0

Re: Message inside a Chart

Anil_Babu_Samineni — Wed, 27 Jul 2016 17:01:05 GMT

You need to calculate depends on your BRD from your Conditional calculation on General tab of your Chart. Then choose Error Messages and Go to that Calculation Condition Unfulfilled then write what ever you want

Good Luck

Re: Message inside a Chart

Anonymous — Wed, 27 Jul 2016 17:03:07 GMT

Thank you!