Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ebc
Employee
Employee

Load Expression Formulas

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

jsaradhi
Specialist
Specialist

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!