topic Count with multiple conditions in QlikView

Count with multiple conditions

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have issues with a mutliple count condition function.

Below 2 expressions works fine:

(count({<[Status]={'Perdue'}>} [ID opportunité]))
(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}>} [ID offre]))

But when I want to create a new expression by putting the expression 1 inside expression 2 so having 3 conditions in total, it doesn't work.

Here is the expression with which I struggle:

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))", Status={'Perdue'}>} [ID opportunité]))

Many thank for your help!!

PS: I am using Personal edition

effinty2112 — Wed, 13 Jul 2016 14:21:34 GMT

Hi Christophe,

There appears to be a curly bracket missing. I've added it in bold here:

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}, Status={'Perdue'}>} [ID opportunité]))

Try it again and good luck

Andrew

Wed, 13 Jul 2016 14:33:07 GMT

Awesome you made my day

effinty2112 — Wed, 13 Jul 2016 14:45:25 GMT

Well Christophe your reply made mine.