Create "Reporting Month" field and count values in pivot tables based on reporting month
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.
