Create "Reporting Month" field and count values in pivot tables based on reporting month

[Anonymous]

Hi Guys,

I am very new to Qlik so any help would be great!

I have data that is shown as below:

Complaint Date entered	Complaint Solve Date	Complaint Stage	Product
1/07/2018	15/08/2018	1	A
2/06/2018	18/07/2018	2	B
3/05/2018	12/06/2018	3	C
4/02/2018	12/03/2018	4	C
1/07/2018	1/08/2018	3	B
2/06/2018	29/06/2018	2	A
3/05/2018	9/06/2018	1	C
4/02/2018	11/03/2018	5	C
1/07/2018	12/08/2018	1	B
2/06/2018	10/07/2018	2	A
3/05/2018	3/06/2018	4	C
4/05/2018	19/05/2018	6	A

I want to create 2 pivot tables, side by side where Product Code is the Row, Complaint Stage is the Column and see the number solved and entered for a specific month.

If for example I set reporting month = July as a field, In the measure box, I can have it CountIf(Complaint Date Entered.YearMonth = Reporting Date. YearMonth) and the same for Complaint Solved Date?

Is there any tutorials where I can learn how to use date expressions/syntax in Qlik? I am very familiar with how to visualise data, no experience however with syntax itself.

Thanks