How to Group by query for multiple KPI's

tauceef9 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to Group by query for multiple KPI's

MindaugasBacius — Thu, 01 Dec 2016 08:24:47 GMT

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.