topic Maintaining the same expressions within multiple documents in QlikView

Maintaining the same expressions within multiple documents

tabletuner — Tue, 28 Dec 2010 19:35:19 GMT

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

Maintaining the same expressions within multiple documents

Tue, 28 Dec 2010 23:07:13 GMT

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.

Maintaining the same expressions within multiple documents

tabletuner — Wed, 29 Dec 2010 22:58:01 GMT

Could you post an example please 🙂

Maintaining the same expressions within multiple documents

pover — Wed, 29 Dec 2010 23:22:24 GMT

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.

Maintaining the same expressions within multiple documents

tabletuner — Mon, 03 Jan 2011 15:26:45 GMT

Thanks all. I got it working!

Regards,

Tjeerd