# Qlik Sense App Development

Not applicable

## convert if in to setanalysis

Hi All ,

Help me convert the below if statement in to setanalysis.

sum(if(vJCEKPI1='A' and Date>=DateCurrPeriodStart and DorC='C',DCAmount,

if(vJCEKPI1='C' and Date>=DateCurrPeriodStart and DorC='C',DCCount)))

Thanks

Charleo

19 Replies
MVP

## Re: convert if in to setanalysis

May be this

Sum({<vJCEKPI1 = {'A'}, Date = {"\$(='>=' & DateCurrPeriodStart)"}, DorC = {'C'}>} DCAmount) +

Sum({<vJCEKPI1 = {'C'}, Date = {"\$(='>=' & DateCurrPeriodStart)"}, DorC = {'C'}>} DCCount)

Contributor III

## Re: convert if in to setanalysis

=Sum({\$<vJCEKPI1={'A'},Date={">=DateCurrPeriodStart"},DorC={'C'}>}DCAmount)+

Sum({\$<vJCEKPI1={'C'},Date={">=DateCurrPeriodStart"},DorC={'C'}>}DCCount)

hope it helps

Not applicable

## Re: convert if in to setanalysis

Its not working dude...there is a variable to select 'A','C', its not reflecting sunny

Thanks

Charleo

Not applicable

## Re: convert if in to setanalysis

Its not working dude,

Thanks

Charleo

MVP

## Re: convert if in to setanalysis

Would you be able to share a sample?

Esteemed Contributor II

## Re: convert if in to setanalysis

what is the definition for vJCEKPI1

Esteemed Contributor II

## Re: convert if in to setanalysis

May be you only need \$ expansion for variables

Sum({<\$(vJCEKPI1) = {'A'}, Date = {"\$(='>=' & DateCurrPeriodStart)"}, DorC = {'C'}>} DCAmount) +

Sum({<\$(vJCEKPI1) = {'C'}, Date = {"\$(='>=' & DateCurrPeriodStart)"}, DorC = {'C'}>} DCCount)

Not applicable

## Re: convert if in to setanalysis

Hey Vineeth,

Its not working dude.

Thanks

charleo

Not applicable

## Re: convert if in to setanalysis

'C' is the defination

regards

Charleo