Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression for summarizing categories

Hi,

I have the following data in my model already (sample):

ID          AddedOn          FinishedBy

1          Sprint1               Sprint3

2          Sprint1               Sprint1

3          Sprint2               Sprint3

4          Sprint2               Sprint2

5          Sprint2               Sprint2

6          Sprint2               Sprint3

7          Sprint3               Sprint3

and I want to be able to put it in a table like below:

Sprint          No. of New/Additions          No. of Finished

Sprint1          2                                        1

Sprint2          4                                        2

Sprint3          1                                        4

How should I formulate the expression of my table/chart?

Thanks!

>Ronald

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw for two solutions.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw for two solutions.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert! I should have figured to try using If. I am leaning more on using the solution using If as the number of sprints can grow.

Thanks again!

Kushal_Chawda

Hi

I know you already got the solution, but still find the attched this one.

Regards,

Kush