Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Returning a Negative Value

Hello,

 

The expression below for some reason is returning a negative value, when it shouldnt.

 

=(SUM({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}([Int by Assigned ESS]='1')))

 

Any ideas.

1 Solution

Accepted Solutions
Henri_Rufin
Luminary
Luminary

Hi,

I don't know what you're trying to achieve with this ([Int by Assigned ESS]='1') but we should find here your KPI without the condition ='1'. If you wish to apply an additional condition, it should be found in your set statement. 

The formula should look like something like this :

=(SUM({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"},[Int by Assigned ESS]={'1'}>}YOURFIELDKPI))

View solution in original post

1 Reply
Henri_Rufin
Luminary
Luminary

Hi,

I don't know what you're trying to achieve with this ([Int by Assigned ESS]='1') but we should find here your KPI without the condition ='1'. If you wish to apply an additional condition, it should be found in your set statement. 

The formula should look like something like this :

=(SUM({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"},[Int by Assigned ESS]={'1'}>}YOURFIELDKPI))