Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Count with multiple conditions

Hi,

I have issues with a mutliple count condition function.

Below 2 expressions works fine:

  1. (count({<[Status]={'Perdue'}>} [ID opportunité]))
  2. (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

1 Solution

Accepted Solutions
effinty2112
Honored Contributor

Re: Count with multiple conditions

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

View solution in original post

3 Replies
effinty2112
Honored Contributor

Re: Count with multiple conditions

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

View solution in original post

Not applicable

Re: Count with multiple conditions

Awesome you made my day

effinty2112
Honored Contributor

Re: Count with multiple conditions

Well Christophe your reply made mine.