topic Indirect function (Excel) in QlikView in QlikView

Indirect function (Excel) in QlikView

Fri, 26 Feb 2016 19:23:27 GMT

Hello,

I wonder if there is a similar function in QlikView to Excel INDIRECT. The goal was to load a table inside the cloud with all expressions, there the objects would use only this function and expression would be different for each line. Below is an example of how it would table with the expressions:

Account	Expression
Sale of Machines	Sum (Value)
Sale of Parts	Sum (Value)
Sale of Services	Sum (Value)
GROSS SALES	Sum ({$ <Account = { 'Sale of Machines', 'Sale of Parts', 'Sale of Services'}>} Value)

Re: Indirect function (Excel) in QlikView

marcus_sommer — Sat, 27 Feb 2016 19:29:52 GMT

You could maintain your expression in an external file or database and use them within various object-parts but you couldn't use them in a kind of indirect-function respectively an evaluate-function on a row-level. Single-row expressions could be interpeted with The Magic of Dollar Expansions. But with some efforts are workarounds for multiple rows possible. I think this discussion will be helpful for you: Re: AllowMacroFunctionsInExpressions AND ActiveDocument.Evaluate()

- Marcus