topic Combining two Set Analysis into 1 equation in QlikView

Combining two Set Analysis into 1 equation

Wed, 25 Nov 2020 16:16:04 GMT

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!

Anonymous — Tue, 17 May 2016 15:44:08 GMT

your Expression Looks good.

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

is there any data which fits both conditions?

trdandamudi — Tue, 17 May 2016 15:48:08 GMT

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

Tue, 17 May 2016 16:35:03 GMT

I figured it out.

Actually the right expression would be:

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

sunny_talwar — Tue, 17 May 2016 16:36:03 GMT

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