Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Would you be able to elaborate on this using an example?
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:
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
(p1 from 01.jul.2019+p2 from 01.jul.2019) - (p1 from 01.jan.2019+p2 from 01.jan.2019)
p1, p2, p3 are numbers?
no, p1,p2,p3,p4 are column values varchar(255)
How can I sum varchar? p1+p2 will give me what?
I want to count all rows with P1+P2 based on a dates