Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III
‎2021-02-12 10:26 AM

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.

342 Views
0 Likes
1 Solution

Accepted Solutions
Henri_Rufin
Luminary
Luminary
‎2021-02-13 04:41 AM

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

312 Views
1 Reply
Henri_Rufin
Luminary
Luminary
‎2021-02-13 04:41 AM

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))

313 Views