Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated error message

Hi

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'

1 Solution

Accepted Solutions
rupamjyotidas
Specialist
Specialist

Add this in your Equation

ALT(YourEquation, 'no data to display')

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

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

Like here:Capture.PNG

rupamjyotidas
Specialist
Specialist

Add this in your Equation

ALT(YourEquation, 'no data to display')

Not applicable
Author

Thank you Rupam,  That solved my problem