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