topic Re: If with setanalysis in QlikView

If with setanalysis

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I need to convert if condition into setanalysis as below.

if( Child_3 = 'Package'

sum(BDA) + Sum(GBA),sum(Outstand))

- Priya

sunny_talwar — Mon, 27 Jun 2016 13:51:42 GMT

May be this:

Sum({<Child_3 = {'Package'}>}BDA) + Sum({<Child_3 = {'Package'}>}GBA) + Sum({<Child_3 -= {'Package'}>}Outstand)

RangeSum(Sum({<Child_3 = {'Package'}>}BDA), Sum({<Child_3 = {'Package'}>}GBA), Sum({<Child_3 -= {'Package'}>}Outstand))

priyarane — Mon, 27 Jun 2016 14:01:38 GMT

I have pivot table child_3 is a dimension, for child3 there are multiple values like below

Child_3 Expr(for all other than 'Package', expr is sum(outstanding) for package expr is sum(BDA) + sum(GBA)

xxy

yyz

'Package'

sunny_talwar — Mon, 27 Jun 2016 14:03:46 GMT

Right, did the above expression not work? Can you provide a sample?

priyarane — Mon, 27 Jun 2016 14:07:09 GMT

above expr didn't work

sunny_talwar — Mon, 27 Jun 2016 14:08:26 GMT

Would you be able to share a sample?

priyarane — Mon, 27 Jun 2016 14:24:25 GMT

Data:

sunny_talwar — Mon, 27 Jun 2016 14:30:18 GMT

Seems to be working just like the if statement:

priyarane — Mon, 27 Jun 2016 14:34:11 GMT

Thanks Sunny... it is working

sunny_talwar — Mon, 27 Jun 2016 14:36:56 GMT

Awesome

I wasn't sure what I might have been missing, but I am glad we were able to resolve it quick enough.

Best,

Sunny