Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nsigitsutanto
Contributor
Contributor

setting count condition for KPI

Hello, I would like to set a condition for KPI. So, the problem is I have two columns consist of two dates. These dates refer to planned date and execution date. I would like to count how many item that has different dates and show the total of these items with KPI. What expression that I could use to do this condition? Thank you.

1 Reply
da_pagnott
Contributor III
Contributor III

Hi,

could be something like this, to count how many days you have in your column DATE that are different from Date 1 and Date 2.

=Count({<DATE=-{"$(=Date2)","$(=Date1)"}>} distinct DATE)