Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
DipeshVadgama
Partner - Creator II
Partner - Creator II

Show Textbox if Chart shows "No data to display"

Hi,

I am trying to show Textbox on chart saying "On Time" if there is "No data to display". Otherwise show charts.

8 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Dipesh,

There's the calculation conditions in qlikview and you can set an accordingly message to it (like bellow).

Sample.png

So my condtiotion for the chart is some kind of calculation (in my case, always false) and it shows the error message i've set in the box as 'Test'.

Felipe.

its_anandrjs

Rather than using Text object use chart properties for this go to Error Message >> Calculation Condition Unfiled >> and write your message over there.

Kushal_Chawda

In chart properties->General tab-> In calculated condition use below expression

= (YourExpression) > 0


Click on Error Message in General tab of chart properties


Click on " calculation condition unfulfiled"  and write " On Time"

DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

Thanks, But i have multiple charts which i would like to cover with textbox or image

DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

Thanks all, But i have multiple charts which i would like to cover with textbox or image

Kushal_Chawda

In text object properties -> Layout ->Conditional put below expression

= if(YourChartExpression <=0,1,0)


This text object will be visible when there no data for particular expression

felipedl
Partner - Specialist III
Partner - Specialist III

Use the "Conditional" in Layout tab than.

As you won't have a number on the calculation, the chart will not be displayed

In my case, i've tested with a set analysis that wont return a value to me

Sample.png

As i press the "OK" button, the chart disappears.

Sample2.png

And putting a textbox behind the chart.

Sample.png

its_anandrjs

You can try the text box trick also.

See the attached also