Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Counting based on selection across entire dataset

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Counting based on selection across entire dataset

Hi,

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

See Attached

Andy

Highlighted
MVP & Luminary
MVP & Luminary

Re: Counting based on selection across entire dataset

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Counting based on selection across entire dataset

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!