Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Indirect function (Excel) in QlikView

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:


AccountExpression
Sale of MachinesSum (Value)
Sale of PartsSum (Value)
Sale of ServicesSum (Value)
GROSS SALESSum ({$ <Account = { 'Sale of Machines', 'Sale of Parts', 'Sale of Services'}>} Value)
1 Reply
marcus_sommer

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