is it possible to move the charts/Objects based on Conditions....??

[dhasharadh]

Hi Experts,

we have a requirement where we have to Move the Objects including charts and list boxes etc. based on a condition.

we are showing two charts based on the drill down feature.Please look into the below image for more information.

there are total 5 charts ,out of the 3 will be always displayed and 2 charts will be displayed based on condition.according to the these 2 charts remaining charts have to adjust/move there place in the dashboard. is this possible with triggers

Please find the attached image for more information.

It will be help full if any one you respond with best way to do it.Thanks in advance.

Please let me know if you need any more information.

i think we can do this using show/hide condition where i have to take 3 copies each chart and keep it in different position.

which is a typical task for me. Please suggest some other methods.

Best Regards,

Dhasharadh.

[robert_mika]

There is not option to change the X-pos and Y-pos of the object

you can use hide/show condition on an object or create other sheets we the "moved" charts

[sunny_talwar]

I can't think of another way except hide show functionality with multiple charts to get this done. May be somebody know of a Macro to do it?

[robert_mika]

I believe there is a macro but in my view that may do more harm than good if used on Access Point

[dhasharadh]

‌hi sunny thanks for tha response.

if I use show/hide method for achieving this I have to take 3 copies of 30 objects and I have to keep them in different positions and show them based on condition..

is it going to effect on my app performance,if not then I vil go with this method even though its very hectic to do ...

[dhasharadh]

‌thanks Robert for the quick response...

we are not allowed to use macros   ...

if I take 3 copies of each set which is having around 30 objects ,and hide them is it good approach to do..please let me know if you know any other alternate for this...

thanks again...

[robert_mika]

I asked similar question here

Performance -Hidden vs different tab

Follow links in the post for more information.

I do not think that at the moment you have any other option.

[marcus_sommer]

I suggest to consider a complete different approach of showing objects and usability where no such positioning and/or hiding of objects is needed. It makes the things only complicated and adds no more value to the main-purpose of an application - to get insights of the data and to be able to analyze them.

Regarding to this I recommend to read the book: Creating Stunning Dashboards with QlikView from Julian Villafuerte, see also: Books and literature.

- Marcus

[Anonymous]

It is possible to use a macro to move a sheet object.

sub moveChartTopRight

  set oChart = ActiveDocument.GetSheetObject("Hidden chart 1")

  set fr = oChart.GetFrameDef

  set pos = fr.Rect

  pos.Top = 70

  pos.left = 2890

  oChart.SetFrameDef fr

  set oChart = nothing

  set fr = nothing

  set pos = nothing

end sub