Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

timothy_forbes
Not applicable

Can someone help me create an expression with the following conditions?

I am trying to create a distinct count condition if certain conditions are met.

The conditions being, [Previous Months Open Count] = 1, [No Date Closed Task] = 0 and the date(opened) < monthstart(today(),number)

Can someone please help me create this expression?

4 Replies
sunny_talwar
Not applicable

Re: Can someone help me create an expression with the following conditions?

May be this:

Count(DISTINCT {<[Previous Months Open Count] = {1}, [No Date Closed Task] = {0}, opened = {"$(='<' Date(MonthStart(Today()), 'DateFieldFormatHere'))"}>} FieldName)

Here replace FieldName with whatever you are counting. and DateFieldFormatHere with whatever you opened date format is.

Best,

Sunny

timothy_forbes
Not applicable

Re: Can someone help me create an expression with the following conditions?

Thank you for the response although it isn't getting the proper count.

sunny_talwar
Not applicable

Re: Can someone help me create an expression with the following conditions?

Can you elaborate on what is a proper count? Share a sample?

timothy_forbes
Not applicable

Re: Can someone help me create an expression with the following conditions?

I am trying to mimic this excel sumif statement.

=SUMIFS(Tasks!$X:$X,Tasks!$A:$A,$B$6,Tasks!$B:$B,$B7,Tasks!$Y:$Y,1,Tasks!$AA:$AA,0)

X refers to count column which consists of 1's which are summed based on other paramaters

B6 refers to a specific manager

B7 refers to an assignment group

Y refers to Previous Months Open Count which should  be set at 1

AA refers to No Date Closed Task which should be set at 0