topic Re: Restore a chart and have a text box updated in QlikView

Restore a chart and have a text box updated

danialier — Thu, 13 Mar 2014 08:03:48 GMT

Hello,

I have two bar charts minimized, one for hardware revenue and another for supplies revenue. When I restore one of these bar charts I want a text box next to the bar chart to show the revenue for the restored bar chart.

For instance, when I restore the hardware bar chart I want the text box to show the revenue of the hardware, however when I restore the supplies bar chart (and as consequence having the hardware bar chart minimized 'cause I have the automonimize selected), then I want the text box to show the revenue of the supplies.

Is there any way I can do that ?

thks,dani

Re: Restore a chart and have a text box updated

MK_QSL — Thu, 13 Mar 2014 08:07:27 GMT

instead of showing a separate text box, go to presentation tab of each bar chart and use Text in chart.

click on add and under text expression write something like SUM(REVENUE) as per your field name

UPDATE : check enclosed file...

UPDATE : Check updated file showing criteria as per your requirements.

Re: Restore a chart and have a text box updated

maxgro — Thu, 13 Mar 2014 08:09:46 GMT

workaround

- create a grid container (A) with hardware bar chart and hardware text box

- create a grid container (B) with supplies bar chart and supplies text box

- create a single object container and insert containers A and B

Re: Restore a chart and have a text box updated

veidlburkhard — Thu, 13 Mar 2014 09:04:43 GMT

Hi Dani,

I would recommend to create a button to restore the bar chart. This button should simultaneously set a variable, which conditionally shows your textbox.

Regards

Burkhard