topic Re: Help on IF v. Set Analysis in QlikView

Help on IF v. Set Analysis

bazzaonline — Tue, 24 Feb 2015 13:41:20 GMT

Hello, I have the below expression which works fine at an overall level,

([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS))*100

However I need to be able to add a criteria so it only works on a sub set of data. In this case when the Dimension 'Flow' equals 'Rapid'.

How do I do this? I tried

if(Flow='Rapid',sum([NPSP])/sum(NPSS)-sum([NPSD])/sum(NPSS))*100

but no joy.

Any ideas?

simospa — Tue, 24 Feb 2015 13:58:25 GMT

Hi Paul,

not sure I undesrstood what do you want...

Try to see the attachment.

Let me know.

maxgro — Tue, 24 Feb 2015 14:24:40 GMT

maybe

sum({$ <Flow={Rapid}>} NPSP) / ......

Anonymous — Tue, 24 Feb 2015 18:07:51 GMT

try.

sum({<Flow={'Rapid'}>}NPSP)/sum({<Flow={'Rapid'}>}NPSS)-sum({<Flow={'Rapid'}>NPSD}/sum({<Flow={'Rapid'}>NPSS}*100