topic Calculated error message in QlikView

Calculated error message

Wed, 25 Nov 2020 16:16:04 GMT

i have a list box with date field

i'm showing the last 3 months data

for suppose if my current month ie(selected month has no data)

i want to display an error message that no data to display in the chart

how can we set error messages in qlikview

In the below image i have a list box and straight table, where i'm claculating the last 4 months data

if i dont have data in the current month my table should show an error message 'no data to display'

vishsaggi — Wed, 26 Oct 2016 15:19:44 GMT

You can try giving a calculation condition in General Tab of any chart table properties with a custom error message.

Like here:

rupamjyotidas — Wed, 26 Oct 2016 15:24:39 GMT

Add this in your Equation

ALT(YourEquation, 'no data to display')

Wed, 26 Oct 2016 15:42:59 GMT

Thank you Rupam, That solved my problem