Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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.
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
Hope this might help you. see the attachment.
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?
Right click on sheet tab--- click sheet properties and goto trigger tab... you can see the actions i have added there.
Regards,
Shumail Hussain
Excellent, thanks very much for your help 🙂
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....
Hi Umang,
In 8.5 we have Macro Tab instead of Trigger.. Best of luck
Regards,
Shumail Hussain
Hi
Qlikview 9.0 given functionality container where you insert one or more chart.
see in example what is new qv9.
Regards
Ashish Srivastava