topic Re: Load Expression Formulas in QlikView

Load Expression Formulas

ebc — Mon, 02 Mar 2015 18:15:08 GMT

I am trying to load a list of formulas that I want to calculate in expressions. Once I have loaded some data and a list of metrics along with their formula, I am trying to use a dollar sign expansion on each formula to create the expression.

I essentially created a table that lists out each metric that I want to calculate. The problem I think I am having is trying to use a different formula in each row (see attached example). The calculation works fine when I have a single metric selected but cannot calculate when I list out all metrics.

Re: Load Expression Formulas

Gysbert_Wassenaar — Mon, 02 Mar 2015 18:28:10 GMT

See this discussion: Expressions in Fields. In particular jontydkpi's answer.

Re: Load Expression Formulas

Anonymous — Mon, 02 Mar 2015 18:39:42 GMT

as far as i know, that is not possible the way you are attempting. but options to consider:

option 1: if the numbers are going to be static since you used {1}, you could try alternate states but this is not a clean solution at all...it will get messy with too many objects as the number of metrics increase!

option 2: i rather do it as variables and calculate them there. pfa.

edit: i totally forgot about Jonathan's reply! thanks for reminding me again!