Discussion Board for collaboration related to Creating Analytics for QlikView.
I am very new to Qlik so any help would be great!
I have data that is shown as below:
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.