topic Re: Dynamic Chart position in sheet according to selection in QlikView

Dynamic Chart position in sheet according to selection

Thu, 27 Jun 2013 17:09:04 GMT

Have an issue with aligning multiple charts in a sheet, charts are viewed based on selection of the user.

Would like the charts to allign one below the other based on the selections made.

Also tried putting them in a container grid, doesnt work either.

Please see the attached example for more detail.

Do I have to use a macro, or is there any way to change position through conditional show.

Thanks in advance.

Re: Dynamic Chart position in sheet according to selection

Gysbert_Wassenaar — Thu, 27 Jun 2013 17:51:08 GMT

Qlikview doesn't support relative positioning of objects. If you want to do that you'll have to create a macro to calculate the positions first and then position the objects too. I'm pretty sure it can be done, but I'm not going to figure out how to do that.

Re: Dynamic Chart position in sheet according to selection

Fri, 28 Jun 2013 12:48:58 GMT

Thank you for your reply, yes seems like macro is the only option.

Can somebody give me an idea on how to proceed with the Macro.

Re: Dynamic Chart position in sheet according to selection

Tue, 16 Jul 2013 12:12:01 GMT

Got the macro to work finally, might help others.

Re: Dynamic Chart position in sheet according to selection

Wed, 24 Jul 2013 15:52:03 GMT

I am trying to do a similar thing but the problem is i need to click on the macro button everytime i want the macro to run. Any help would be appreciated.

Thanks