topic Re: Set Analysis Query in QlikView

Set Analysis Query

Mon, 29 Aug 2011 22:37:31 GMT

Good Day, I have the following expression that I would like to convert to Set Analysis:

=Sum(If([Field1] = 'Value1',
IF([Field2] = 'Value2',
IF( [Field3]>0, [Field4]))))

What I have so far is this:

=Sum({$<[Field1] ={'Value1'},
"=Sum({ $ <[Field2] = {'Value2'}>}
[Field3]) >0"> }[Field4])

but it does not give me the desired result. Anybody know where I'm going wrong?

johnw — Mon, 29 Aug 2011 22:54:42 GMT

I believe this (and be sure to note single vs. double quotes - single indicates a literal, double indicates a search string):

sum({<Field1={'Value1},Field2={'Value2'},Field3={">0"}>} Field4)

Mon, 29 Aug 2011 23:01:47 GMT

Hi John, thank you very much, that did the trick. Also thank you very much for the tip.