Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Multiple Count IFs

Hi

I am trying to create a count IF check with two variables. I want to count the number of entries which have existed for over two years and it has been two years since they have been inspected and return their identification.

This is the formula I have created so far, but it does not work.

Count({<Today()-StartDate>730, Today()-InspectionDate>730>} ID)

The check in Excel is =IF(AND(TODAY()-C5>730,TODAY()-D5>730),1,0)

IDCompanyStart DataInspection Date
1A01/06/201213/09/20140
2B05/07/201400
3C25/10/201001
4B26/04/201101
5A26/04/201120/10/20130
6C26/04/201101
7A05/07/201400
8B26/04/201101
9C05/07/201400
10B05/07/201001

Then count the number of occasions it happens for each company

A 0

B 3

C 2

Any help would be appreciated.

Thanks,

Iain

1 Reply

Re: Multiple Count IFs

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser