How to get last row value when using cyclic groups

Thu, 09 Oct 2014 09:41:55 GMT

I would like to create a bar chart that has as time dimension a cyclic group Day/Week/Month and as expression something that shows the number of total members at the end of the time period, not the average or sum , but the last row.

For example if Day is selected

Day	Number of Members
10.04.14	44776
11.04.14	44815
14.04.14	44854
15.04.14	44887
16.04.14	44921
17.04.14	44946
18.04.14	44946
21.04.14	44946
22.04.14	44952
23.04.14	44950
24.04.14	44962
25.04.14	44989
28.04.14	45000
30.04.14	45073
01.05.14	44920
02.05.14	44945
05.05.14	44969
06.05.14	45002
07.05.14	45056
08.05.14	45120
09.05.14	45139
12.05.14	45139
13.05.14	45179
14.05.14	45225
15.05.14	45247
16.05.14	45225
19.05.14	45309
20.05.14	45348
21.05.14	45369
22.05.14	45389
23.05.14	45410
26.05.14	45455
28.05.14	45455
29.05.14	45455
30.05.14	45455
02.06.14	45282
03.06.14	45443
04.06.14	45443
05.06.14	45442
06.06.14	45502
09.06.14	45502
10.06.14	45510

if Week is selected then I have

Week	Number of Members
2014/15	44815
2014/16	44946
2014/17	44989
2014/18	44945
…	…

that is for each week I have the number of members of the last day of that week

if Month is selected then I have

Month	Number of Members
avr. 2014	45000
mai 2014	45455
juin 2014	45510

that is for each month I have the number of members of the last day of that month.

Since I work with business days, last day of week or month for me is the last data point I have for that week or month not the calendar day.

Does anyone know how to make such a chart?

topic How to get last row value when using cyclic groups in QlikView

How to get last row value when using cyclic groups