Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting based on selection across entire dataset

Hey everyone,

I'm trying to group weekly data in a graph chart, basically it's number of processes initiated by users in a given week. I have created a master calendar where I get the week number (for 2015 until today), and I want to see per week, the number of processes started on that week, and also the number of processes finished on that same week, side by side. The problem I run into is that I get the mere count of processes on a certain week based on my selection, instead of all the processes that were finished in the same week as my selection. So for below example:

Process ID     StartWeek     EndWeek

20084662          15                    16

10254531          15                    15         

10254532          15                    15    

20132295          15                    17

20132294          15                    16

20134879          14                    15

20136216          14                    14

20018337          13                    15                             

10254538          15                    16

10254540          12                    13                                                 

10254541          14                    14

For week 15, I would like to get the number 4 (Number of processes that were finished in week 15), but I keep getting 6 (count of end weeks that started in week 15). I've tried a few different things but nothing worked. Any ideas? Thanks in advance!

Panos

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi,

use EndWeek as your dimension and count({Process ID]) as your expression.

See Attached

Andy

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi both, thanks for your help, I could only find the time to test them just now. Gysbert's answer with a few changes was what I was looking for, thanks!