Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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