Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to get last row value when using cyclic groups

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

DayNumber of Members
10.04.1444776
11.04.1444815
14.04.1444854
15.04.1444887
16.04.1444921
17.04.1444946
18.04.1444946
21.04.1444946
22.04.1444952
23.04.1444950
24.04.1444962
25.04.1444989
28.04.1445000
30.04.1445073
01.05.1444920
02.05.1444945
05.05.1444969
06.05.1445002
07.05.1445056
08.05.1445120
09.05.1445139
12.05.1445139
13.05.1445179
14.05.1445225
15.05.1445247
16.05.1445225
19.05.1445309
20.05.1445348
21.05.1445369
22.05.1445389
23.05.1445410
26.05.1445455
28.05.1445455
29.05.1445455
30.05.1445455
02.06.1445282
03.06.1445443
04.06.1445443
05.06.1445442
06.06.1445502
09.06.1445502
10.06.1445510

if Week is selected then I have

WeekNumber of Members
2014/1544815
2014/1644946
2014/1744989
2014/1844945

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

MonthNumber of Members
avr. 201445000
mai 201445455
juin 201445510

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?

Tags (4)
Community Browser