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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Alarkis
Contributor III
Contributor III

KPI not showing correct number (Expression)

Hello,

I have a KPI that is not showing correct result

Image below:

 

Alarkis_0-1595935437585.png

 

as you can see the TOTAL_COST result is wrong 

the expression is (COST_OF_SERVICE  * Number)

 

This is the expression used:

Count({<DateType={'Application_Date'}>}distinct [Application No.])
*
sum({<DateType={'Application_Date'}>}COST_OF_SERVICE)

 

 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Alarkis
Contributor III
Contributor III
Author

Solved:

Sum(aggr(Count({<DateType={'Application_Date'}>}distinct [Application No.])
* sum(COST_OF_SERVICE),COST_OF_SERVICE))

View solution in original post

1 Reply
Alarkis
Contributor III
Contributor III
Author

Solved:

Sum(aggr(Count({<DateType={'Application_Date'}>}distinct [Application No.])
* sum(COST_OF_SERVICE),COST_OF_SERVICE))