Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Help with displaying a chart

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??

Tags (1)
9 Replies
Not applicable

Help with displaying a chart

Hi

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.

Not applicable

Help with displaying a chart

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

shumailh
Contributor III

Help with displaying a chart

Hope this might help you. see the attachment.

Partner
Partner

Help with displaying a chart

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?

shumailh
Contributor III

Help with displaying a chart

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

Regards,
Shumail Hussain

Partner
Partner

Help with displaying a chart

Excellent, thanks very much for your help 🙂

Not applicable

Help with displaying a chart

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....

shumailh
Contributor III

Help with displaying a chart

Hi Umang,

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

Regards,
Shumail Hussain

Not applicable

Help with displaying a chart

Hi

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

see in example what is new qv9.

Regards

Ashish Srivastava