How to add a calculated columns using expression in qlik sense

Fri, 24 Mar 2017 15:13:40 GMT

Hello,

I am trying to add two columns in my table view as shown below.

For simple addition or subtraction I can add a column but when I try to calculate percentage for each row by total of that column and use that calculated field again I get error in expression.

Can anyone please help me with how can I make it in Qlik Sense?

as shown in below table I am trying to add two more columns by performing calculations on existing data

A	B	C	D	E
Unit Name	Allocation	Revenue	% Revenue of total	Proposed_Allocation
Temp 1	101	12	C2/(Sum(Revenue)) * 100	Sum(Allocation)*D2
Temp 2	111	14	C3/(Sum(Revenue)) * 100	Sum(Allocation)*D3
Temp 3	121	15	C4/(Sum(Revenue)) * 100	Sum(Allocation)*D4

Thank You

topic How to add a calculated columns using expression in qlik sense in App Development

How to add a calculated columns using expression in qlik sense