# New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

## Combining two Set Analysis into 1 equation

Hi All,

I'm struggling with this formula. I have 2 set analysis I need to combine

First,

Sum( {<[Region Lvl 1] = {'NA'}>} FY16F)

Second,

Sum( {<[Functional P&L] = { 'IB Fees' }>} FY16F)

So Basically [Region Lvl 1] and [Functional P&L] are columns in my data set.

I thought I can combine two set analysis into 1 by inserting a comma.

Sum( {\$<[Region Lvl 1] =    {'NA'} , [Functional P&L] = {'IB Fees'}>} FY16F)

4 Replies
Partner

## Re: Combining two Set Analysis into 1 equation

what is the outcome? does the result show "-"

is there any data which fits both conditions?

Honored Contributor II

## Re: Combining two Set Analysis into 1 equation

The expression is correct when you combined both of them. What is your expectation of the result ? Can you please share your output.

Not applicable

## Re: Combining two Set Analysis into 1 equation

I figured it out.

Actually the right expression would be:

Sum( {<[Region Lvl 1] = {'NA'} , [Functional P&L] = {'IB Fees'}>} TOTAL(FY16F))

MVP

## Re: Combining two Set Analysis into 1 equation

Is this an OR condition (Either Region Lvl 1 = NA or Functional P&L = IB Fees?

May be this:

Sum({\$<[Region Lvl 1] = {'NA'}> + <[Functional P&L] = {'IB Fees'}>} FY16F)

or just do this:

RangeSum(Sum({<[Region Lvl 1] = {'NA'}>} FY16F), Sum( {<[Functional P&L] = { 'IB Fees' }>} FY16F))