topic Re: How do I select and group values from a same column in QlikView

How do I select and group values from a same column

Javanshir_Mustafayev — Sat, 16 Nov 2024 20:11:25 GMT

Hello Community,

I have a column in my table that corresponds the priority of Jira tasks like:

Priority:

How do I select only P1+P2 and P3+P4 respectively? Also I need to group them by date and substract one sum of P1+P2 of another P1+P2 based on dates?

Re: How do I select and group values from a same column

sunny_talwar — Wed, 28 Aug 2019 11:43:37 GMT

Would you be able to elaborate on this using an example?

Re: How do I select and group values from a same column

Javanshir_Mustafayev — Wed, 28 Aug 2019 12:48:16 GMT

Sure,

I have imported the Jira data into Qlik and there is a column named priority. Priority has five values: P1, P2, P3, P4, N/A

I need to make the following manipulations: summarize the P1 and P2 rows with date from 01/07/2019 and substract the number from another sum of P1+P2 with date from 01/01/2019

Please find screenshots of data imported below:

Re: How do I select and group values from a same column

sunny_talwar — Wed, 28 Aug 2019 13:36:00 GMT

What do you mean summarize? Count them? Avg the time? or something? I still don't think I know what you are looking to do

Re: How do I select and group values from a same column

Javanshir_Mustafayev — Wed, 28 Aug 2019 13:40:49 GMT

(p1 from 01.jul.2019+p2 from 01.jul.2019) - (p1 from 01.jan.2019+p2 from 01.jan.2019)

Re: How do I select and group values from a same column

sunny_talwar — Wed, 28 Aug 2019 14:00:44 GMT

p1, p2, p3 are numbers?

Re: How do I select and group values from a same column

Javanshir_Mustafayev — Wed, 28 Aug 2019 14:16:00 GMT

no, p1,p2,p3,p4 are column values varchar(255)

Re: How do I select and group values from a same column

sunny_talwar — Wed, 28 Aug 2019 14:54:47 GMT

How can I sum varchar? p1+p2 will give me what?

Re: How do I select and group values from a same column

Javanshir_Mustafayev — Thu, 29 Aug 2019 07:14:13 GMT

I want to count all rows with P1+P2 based on a dates