Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Sorry if its sound little obvious but I am really new to qlik.
I am creating a report where in there are multiple KPI's to be displayed like:
Count of Incident by Priority by weekly
Count of Incident by Category by weekly etc...
Now the issue which I have is I am writing a single query with Group by Priority, Category and date
and while creating a report I am selecting Priority, Date and Count for one chart
and Category, Date and Count for another chart
but because of group by on both Priority and Category together in the query I am not getting correct data in the report:
Getting multiple entries for a date with respect to a Priority or Category.
Do I have to create different query for all the KPI's like Priority, Category etc..?
Looking forward for a quick help.
Regards,
Tauceef
Count of Incident by Priority by weekly.
For this you need fields Priority, Week, Incident ID.
Then Simple create a pivot table:
Take a look to the attachment.
The same logic would apply to Count of Incident by Category by weekly etc.