Maintaining the same expressions within multiple documents

[tabletuner]

Hi All,

In my qv environent i have 6 different documents for different user groups.

The 6 documents use the same data cloud.

The 6 documents use the same expressions.

My expressions contain set analysis statements like

sum({$< year={$(=max(year))} sales)

The problem i run into is that when i want to change the expression above, i haveto change it within 6 documents.

What smart way of maintainence would you advise in this situation? Is there a best practise solution for this?

Note: the expressions cant be included with the include statement because the expression in my example contains a value for year that is determined in RUNTIME...

I use the latest release of QV 9

Regards,

Tjeerd

[#2 · Accepted solution]

Load them in from a spreadsheet, then to variables.

Next you can use $ expansion in the places where you need the formula.

You can also expose the variables' value in a textbox to test changes in the set logic without having to reload the document.

[tabletuner]

Could you post an example please 🙂

[pover]

See the attached Excel as an example expression repository and take a look at the following post for the script to save each expression in a variable:

http://community.qlik.com/forums/p/35606/139203.aspx

In QlikView you then just put something like $(vExpression_1) in the expression of the chart in the 6 documents and if you have to change the expression you just change it once in the Excel.

Regards.

[tabletuner]

Thanks all. I got it working!

Regards,

Tjeerd