Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Search instead for
Did you mean:
Partner - Specialist III

## If condition in set analysis

Dear Experts,

I have one requirement.

ID      Plant         Value

100           A                  100

200           A                200

100           B                250

400           A                300

400           B                 280

400           C                 220

I required sum of value based on this condition

1. If ID Start with 1 exclude  Plant A.

2. If ID start with other than 1 then Sum Stock

How could i achieve  this in single expression in without any selection.

I Have done some code Please help:

=sum({<ID={'1*'},Plant-={"A"}>+<Plant={"*"}>}Stock)

Thanks ,

Arvind Patil

14 Replies

why you need if condition if same is doable using set analysis? If condition is not advisable due to it's performance impact.

Contributor III

=sum(Value)- Sum({<ID={"=Left(ID,1) = '1'"} ,Plant={'A'}>} Value)

Partner - Champion III

You need to exclude ID = 1* from the second clause of your set expression:

Sum({<ID = {'1*'}, Plant -= {"A"}> + <ID -= {'1*'}, Plant = { "*"}>} Stock)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator

Hi Arvind,

Please try this,

sum(

{

<ID={'*'}>

-

(<ID={'1*'}>

*

<PLANT={'A'}>)

}

VALUE)

Contributor II

need to use "*" instead of '*'

=sum({<ID={"1*"},Plant-={"A"}>+<ID-={"1*"},Plant={"*"}>}Value)

Community Browser