Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Re: Count based on group condition

What if the Status was "Close"?

Highlighted
Specialist
Specialist

Re: Count based on group condition

If Status was close than at any time it was opened also.. Only open store can close..

Yes its not perfect way to count Service Number .. I just gave an idea..

Highlighted
Specialist
Specialist

Re: Count based on group condition

HEy,

Here it is . Try this and let me know:

Count(Aggr(Count(DISTINCT ServiceNumbers),ServiceNumbers)) - Count(Aggr(Count({<Status = {'Close'}>}DISTINCT ServiceNumbers), ServiceNumbers))

View solution in original post

Highlighted
Not applicable

Re: Count based on group condition

Wow! This works perfectly thanks!

There's also another way that my colleague suggested:

count({<Status={'Open'}, ServiceNumber-=P({<Status={'Close'}>})>}ServiceNumber)

Highlighted
Specialist
Specialist

Re: Count based on group condition

Hey,

But when i tried your given expression it is showing me error. IS it working fine in your case ?

count({<Status={'Open'}, ServiceNumber-=P({<Status={'Close'}>})>}ServiceNumber)


Thanks

Highlighted
Not applicable

Re: Count based on group condition

It does show a syntax error (red underline), but the expression calculates fine.

Highlighted
Specialist
Specialist

Re: Count based on group condition

Hey,

Yeah i see to it . BTW can you tell me how the following function working?? I mean what does it ouputs ?


ServiceNumber-=P({<Status={'Close'}>})