Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

wenjun2016
New Contributor

Add values from two different columns in expression

Hi,

I need to create a dimension using expression.

Below is part of my condition,

if([Premise Type]='03' or [Premise Type]='04' or [Premise Type]='05' or [Premise Type]='EE', if(Matched = 1, (Value1+Value2), Value2), 0))


I need to have the sum of Value1 and Value2, they are two data fields(columns).


What is the expression syntax to add them up?


Thank you.


1 Reply
vinay_hg
Contributor II

Re: Add values from two different columns in expression

add same expression in script and name the field, u can take the sum in measure