Qlik Community

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)

Thanks in Advance for your help!

4 Replies
Partner
Partner

Re: Combining two Set Analysis into 1 equation

your Expression Looks good.

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

is there any data which fits both conditions?

trdandamudi
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))

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))