Multiple Count IFs

Mon, 09 Feb 2015 11:04:05 GMT

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)

ID	Company	Start Data	Inspection Date
1	A	01/06/2012	13/09/2014	0
2	B	05/07/2014	0	0
3	C	25/10/2010	0	1
4	B	26/04/2011	0	1
5	A	26/04/2011	20/10/2013	0
6	C	26/04/2011	0	1
7	A	05/07/2014	0	0
8	B	26/04/2011	0	1
9	C	05/07/2014	0	0
10	B	05/07/2010	0	1

Then count the number of occasions it happens for each company

A 0

B 3

C 2

Any help would be appreciated.

Thanks,

Iain

Re: Multiple Count IFs

Gysbert_Wassenaar — Mon, 09 Feb 2015 11:18:40 GMT

See attached qvw.

topic Multiple Count IFs in Qlik Learning Discussions

Multiple Count IFs

Re: Multiple Count IFs