How do I select and group values from a same column

[Javanshir_Mustafayev]

Hello Community,

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

Priority:

P1

P2

P4

P3

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?

[sunny_talwar]

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

[Javanshir_Mustafayev]

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:

[sunny_talwar]

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

[Javanshir_Mustafayev]

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

[sunny_talwar]

p1, p2, p3 are numbers?

[Javanshir_Mustafayev]

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

[sunny_talwar]

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

[Javanshir_Mustafayev]

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