topic Re: To add chart expressions automatically in QlikView

To add chart expressions automatically

AmCh — Thu, 11 Feb 2021 12:29:37 GMT

Hello all,

I have customised my chart with the following properties:

My goal: Expressions (with their condition, label and definition -variable-) can be added automatically on each script load.

//condition=GetFieldSelections(Systems)='x' and GetFieldSelections([Maintenance costs])='Corrective maintenance costs'

My variables (e.g. CM_Annual_x) are already automatically generated on each script load.

Can someone help me?

Many thanks in advance.

Re: To add chart expressions automatically

edwin — Fri, 12 Feb 2021 00:28:50 GMT

i dont think loading scripts will add expressions in charts. the only case ive seen where data in a way drives the number of expressions is in a pivot. maybe you can remodel your data and use pivot in your chart

Re: To add chart expressions automatically

AmCh — Fri, 12 Feb 2021 09:52:51 GMT

What about an action button that adds a new variable (that saves the expression)?
Do you have an alternative other than loading scripts to add expressions to charts?

Many thanks in advance.

Re: To add chart expressions automatically

edwin — Fri, 12 Feb 2021 14:17:11 GMT

Expressions are manually added to a chart at dev time not at run time.

what is the user experience that drives this requirement? if you articulate the pure business requirement maybe that will help others understand what the underlying objective is

Re: To add chart expressions automatically

AmCh — Tue, 16 Feb 2021 15:22:37 GMT

Since the amount of data is always changing, I am looking for a way to make the developer's task more efficient, because I am talking about adding a large amount of expressions to the chart in a daily basis.

It has nothing with the user experience.

Re: To add chart expressions automatically

marcus_sommer — Wed, 17 Feb 2021 13:35:38 GMT

It's not possible to add/change/remove UI objects or parts of it with the script. But it could be done with macros. Another possibility would be to add and/or manipulate the content of the prj-folder.

Whereby I wouldn't recommend it because it wouldn't make anything easier or more efficient else it goes definitely in the opposite direction. And this is mainly independent of the way of doing it (assuming that you would be quite experienced in the methods I mentioned because otherwise you would need some time to learn it and a more or less part of trial & error to get a stable implementation) because the most expensive part is the needed administrative overhead.

If you want to simplify the developer work it would be better to rethink the datamodel and the usability.

- Marcus

Re: To add chart expressions automatically

AmCh — Wed, 17 Feb 2021 15:01:03 GMT

In summary:,there are two ways to solve this/modify UI objects:

1. with macros. Can you give me an introduction on how to do this?

2. rethinking the data model: what do you concretely mean by 'rethinking' in this case?

Thank you in advance.

Re: To add chart expressions automatically

marcus_sommer — Wed, 17 Feb 2021 15:26:41 GMT

To start with macros take a look on the APIGuide.qvw within your install-folder by automation which gives you a good overview about the object-model and has also many examples and explanations.

Usually a finalized application needs not much attention from the developer - there will be occasionally some new/changed requirements which may require some adjustments on the application. So accessing an application maybe 10 times in a year for changes which in 8 times are a matter of a few minutes don't justify such large overhead with so much more complexity.

If your application needs regularly adjustments it hints on an unsuitable datamodel - for example if it contains crosstable-structures in which each new date or new product creates a new field or something similar. In this case it would be really a never ending story ... Better would in this case be to transform the crosstable into a "normal" table.

- Marcus