Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
gauravsingal1
New Contributor

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 enteredComplaint Solve DateComplaint StageProduct
1/07/201815/08/20181A
2/06/201818/07/20182B
3/05/201812/06/20183C
4/02/201812/03/20184C
1/07/20181/08/20183B
2/06/201829/06/20182A
3/05/20189/06/20181C
4/02/201811/03/20185C
1/07/201812/08/20181B
2/06/201810/07/20182A
3/05/20183/06/20184C
4/05/201819/05/20186A

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

Tags (2)