topic Re: Using if vs. coding it in the set analysis in QlikView

Using if vs. coding it in the set analysis

Fri, 15 Jan 2016 16:53:43 GMT

I have a query the first one works but the second one does not.

Works-

if(BOB = 'A',
(sum({$<BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100),
(sum({$<BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100))

Does not work:

sum({$<BOB-={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100
+sum({$<BOB={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100

Why?

Thanks.

Re: Using if vs. coding it in the set analysis

sunny_talwar — Fri, 15 Jan 2016 18:12:56 GMT

Did you do it opposite?

Sum({$<BOB ={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100

+Sum({$<BOB -={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100

Re: Using if vs. coding it in the set analysis

sunny_talwar — Fri, 15 Jan 2016 18:14:36 GMT

Further I would try to use RangeSum() function here to sum them:

RangeSum(Sum({$<BOB = {'A'}, BOB_age = {'$(=DATE(vC))'}, age = {'>=16 <=25'} >} aging_A) * 100, Sum({$<BOB -={'A'}, BOB_age = {'$(=DATE(vC))'}, age = {'>=16 <=25'}>} aging_B) * 100)