topic Re: Dynamically placement of chart objects in QlikView

Dynamically placement of chart objects

punitpopli — Thu, 09 Feb 2017 10:01:44 GMT

Hi Experts,

Just came across a requirement where a user wants all the charts in the application should be placed dynamically based on a selection through a selector.

Consider I have 10 charts in a QVW and we can place it one besides/below the other but to display them dynamically on user selection can be a bit difficult, as we cant input the X and Y position of a chart dynamically (based on my knowledge)

I know this can be done by macro, but will impact the application performance.

Had anyone implement something like this in the past?

Please share your views.

Thanks in advance

-Punit

Re: Dynamically placement of chart objects

vardhancse — Thu, 09 Feb 2017 10:05:32 GMT

Hi Punit,

Charts/Objects hide & show can be done. But your requirement was little different.

What does that filters have?

Re: Dynamically placement of chart objects

Pulkit_Thukral — Thu, 09 Feb 2017 10:07:01 GMT

Try using allow minimize(Check Auto minimize option) and allow maximize buttons under the caption tab.

Re: Dynamically placement of chart objects

vardhancse — Thu, 09 Feb 2017 10:13:56 GMT

Hi,

I think the position should be dynamic location.

If we minimize then the position will be of static right?

Re: Dynamically placement of chart objects

avinashelite — Thu, 09 Feb 2017 10:15:53 GMT

If you have limited set of charts then you could try writing a macro for the same other than that we don't have default way to achieve the same

Re: Dynamically placement of chart objects

punitpopli — Fri, 10 Feb 2017 02:39:28 GMT

yes, I am aware that Macro can be used to achieve the functionality but just wanted to know if their is any other option to achieve the same

Re: Dynamically placement of chart objects

avinashelite — Fri, 10 Feb 2017 05:41:57 GMT

If you have few fixed positions then you could try with the Hide/show if you need complete dynamic positions as per the user then macro is the only option .

Hope you got the answers

Re: Dynamically placement of chart objects

marcus_sommer — Fri, 10 Feb 2017 12:07:41 GMT

Aren't there too many possibilities in the combination of objects and their position you could use the above mentioned approach to control their visibility. Otherwise you will need a macro-solution although it's thinkable to get a similar solution with an document extension or by manipulating various of the qlik js-scripts which are used for displaying the objects within the access point - whereby both "alternatives" would be a lot complexer than a macro-solution.

Beside these complex and expensive approaches - why not just using drag'n drop of the objects?

- Marcus

Re: Dynamically placement of chart objects

punitpopli — Mon, 13 Feb 2017 03:47:03 GMT

Thanks Marcus for your reply

by Drag n drop did you mean allow user to create a chart by their own?

by adding a sheet object on access point and follow from their?

Re: Dynamically placement of chart objects

marcus_sommer — Mon, 13 Feb 2017 07:47:48 GMT

No, I meant the ability to move and size objects with the mouse if you goes on the title, a column-header or a border which switched the cursor to an arrow and enabled you to adjust them. This is a default-feature and is independent from the allowance (qmc-option by each application controlable by users or user-groups) to add new objects or the change of properties from existing objects.

- Marcus

Re: Dynamically placement of chart objects

punitpopli — Tue, 14 Feb 2017 03:29:30 GMT

The users are more interested in selecting the graph name (title) from the list box and when they click on the button all the charts should placed on the sheet per the title selected from the list box.

I think i should go with macro, as this is the only way i will be able to acheive what the users are expecting

Thanks you for all your responses!

-Punit