https://community.qlik.com/t5/App-Development/setting-count-condition-for-KPI/m-p/1559857#M40774 <P>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.</P> Fri, 22 Mar 2019 03:41:30 GMT nsigitsutanto 2019-03-22T03:41:30Z https://community.qlik.com/t5/App-Development/setting-count-condition-for-KPI/m-p/1559857#M40774 <P>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.</P> Fri, 22 Mar 2019 03:41:30 GMT https://community.qlik.com/t5/App-Development/setting-count-condition-for-KPI/m-p/1559857#M40774 nsigitsutanto 2019-03-22T03:41:30Z https://community.qlik.com/t5/App-Development/setting-count-condition-for-KPI/m-p/1560208#M40812 <P>Hi,</P><P>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.</P><P>=Count({&lt;DATE=-{"$(=Date2)","$(=Date1)"}&gt;} distinct DATE)</P> Fri, 22 Mar 2019 15:42:33 GMT https://community.qlik.com/t5/App-Development/setting-count-condition-for-KPI/m-p/1560208#M40812 da_pagnott 2019-03-22T15:42:33Z