Counting based on selection across entire dataset

Thu, 02 Jul 2015 10:02:18 GMT

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

Re: Counting based on selection across entire dataset

awhitfield — Thu, 02 Jul 2015 15:48:08 GMT

Hi,

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

See Attached

Andy

Re: Counting based on selection across entire dataset

Gysbert_Wassenaar — Thu, 02 Jul 2015 15:57:05 GMT

See attached example.

Re: Counting based on selection across entire dataset

Thu, 23 Jul 2015 13:50:14 GMT

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!

topic Re: Counting based on selection across entire dataset in QlikView

Counting based on selection across entire dataset

Re: Counting based on selection across entire dataset

Re: Counting based on selection across entire dataset

Re: Counting based on selection across entire dataset