topic Help with displaying a chart in QlikView

Help with displaying a chart

hopkinsc — Tue, 20 Jul 2010 13:27:54 GMT

Hi,

I have a PIVOT TABLE which is set to autominimise when a STRAIGHT TABLE is selected. The pivot table only shows summary information, so it is quite small on the screen, whereas the STRAIGHT TABLE is alot bigger. As the PIVOT TABLE is so small and reveals a large empty space in the application, i have placed a pie chart next to it displaying a percentage of sales for the selected criteria.

What i want to do if possible, is to autominimise the pie chart when the STRAIGHT TABLE is selected. Meaning that when the end user selects the STRAIGHT TABLE, the PIVOT TABLE and PIE CHART would autominimise, and when the end user selects the PIVOT TABLE, the PIE CHART would also re-appear.

Can this be done??

Help with displaying a chart

Tue, 20 Jul 2010 13:36:17 GMT

I would probably make it easier, if the space allows (and it sounds like it does).

Make the layer value Bottom for the pie chart, and Top for the straight table (the pivot table can be anything), this means that when the straight table is shown, it will always be on top of the pie chart.

This method works for a small number of objects, because, you should bear in mind that both charts will then be calculating upon selection changes.

Another way to do it would be through buttons to maximise/minimise, using actions to activate objects.

Help with displaying a chart

Tue, 20 Jul 2010 13:47:33 GMT

Hello,

you could create a button 'Toggle View' which changes the value of a variable "varShow" between 0 and 1. (varShow = 1- varShow ... toogles between 0 and 1)

In the charts/ tables you enable the show condition. (varShow=0 for the Pivot and the pie; varShow=1 for the straight table).

That way you can handle the show/ hide of a number of objects.
Afaik hidden objects do not calculate, i.e. you do not risk bad performance due to invisible charts.
The drawback is, that you need the button, i.e. you cannot use the autominize feature.

hth,
Thilo

Help with displaying a chart

shumailh — Tue, 20 Jul 2010 15:13:34 GMT

Hope this might help you. see the attachment.

Help with displaying a chart

hopkinsc — Wed, 21 Jul 2010 10:59:30 GMT

thanks for that Shumail, How did you do it though, i have looked at your attachment but i cant see how it works. Am i missing something?

Help with displaying a chart

shumailh — Wed, 21 Jul 2010 11:09:37 GMT

Right click on sheet tab--- click sheet properties and goto trigger tab... you can see the actions i have added there.

Regards,
Shumail Hussain

Help with displaying a chart

hopkinsc — Wed, 21 Jul 2010 11:26:36 GMT

Excellent, thanks very much for your help 🙂

Help with displaying a chart

Thu, 22 Jul 2010 06:31:00 GMT

Hi,

I tried to go into sheet properties but can not find a TRIGGERS tab .... is that a version problem? I am using ver 8.50....

Help with displaying a chart

shumailh — Thu, 22 Jul 2010 06:44:12 GMT

Hi Umang,

In 8.5 we have Macro Tab instead of Trigger.. Best of luck

Regards,
Shumail Hussain

Help with displaying a chart

Thu, 22 Jul 2010 07:41:39 GMT

Qlikview 9.0 given functionality container where you insert one or more chart.

see in example what is new qv9.

Regards

Ashish Srivastava