topic Re: Count of single column values <= each week number in QlikView

Count of single column values <= each week number

Maddineni_S — Mon, 26 Dec 2022 08:33:28 GMT

Hi,

Submit Week_Num
14
14
14
16
16
19
16
17
17
19
19
19
20
19
20
21
23
23
23
25
25
26
25
26
27
27
31
31
32
32
32
32
33
33
34
34
34
34
34
35
35
35
35
35
36
36
37
37
37
37
37
37
37
38
38
38
39
39
39
40
40
40
23
39
41
41
42
42
43
43
44
44
42
40
33
15
16
16
17
25
26
39
14
18
20
22
23
31
35
36
40
41
45
45
45
45
47
48
48
48

Above column numbers are week numbers from which i would need count of <= each number.

Ex: column have 14 as week number i want count of <=14, 15 like wise for all the numbers which are in the column.

Thanks

Re: Count of single column values <= each week number

Taoufiq_Zarra — Mon, 26 Dec 2022 08:43:34 GMT

Hi @Maddineni_S

can you elaborate or can you share the expected output ?

Re: Count of single column values <= each week number

sidhiq91 — Mon, 26 Dec 2022 08:50:57 GMT

@Maddineni_S as @Taoufiq_Zarra could you please elaborate on your requirement?

Re: Count of single column values <= each week number

Maddineni_S — Mon, 26 Dec 2022 09:16:15 GMT

From the column we have different week numbers are there. from which i need count.

example : data start week si 14. here i need is count of 14 or less then 14 week numbers count . like for 15 week number i need ount of 14 or less then 14 week numbers count .similar till last week number.

Re: Count of single column values <= each week number

Maddineni_S — Mon, 26 Dec 2022 09:16:31 GMT

From the column we have different week numbers are there. from which i need count.

Re: Count of single column values <= each week number

Taoufiq_Zarra — Mon, 26 Dec 2022 09:48:57 GMT

@Maddineni_S

can you share the expected output from this input ?

Re: Count of single column values <= each week number

Maddineni_S — Mon, 26 Dec 2022 11:17:32 GMT

week number	output
for 14	4
for 15	5
for 16	10