Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) |
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