Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New 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
New Contributor III

Re: setting count condition for KPI


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)