i have a table with date, week # &# of days as fields. Need to create a table a below. Please suggest how to do this in Qlikview.

[#1]

Database:

SBD	# of Days	Week
03/08/2017	1	W31
05/08/2017	1	W31
05/08/2017	1	W31
03/08/2017	1	W31
04/08/2017	1	W31
04/08/2017	1	W31
07/08/2017	1	W32
10/08/2017	1	W32
10/08/2017	1	W32
10/08/2017	1	W32
08/08/2017	1	W32
19/08/2017	5	W33

Requirement:

Week	Start Date	End Date	# of days
W31	03/08/2017	05/08/2017	3
W32	07/08/2017	10/08/2017	3
W33	14/08/2017	19/08/2017	5

[Anil_Babu_Samineni]

May be this?

Week as Dimension

Expressions are

1) Min(SBD)

2) Max(SBD)

3) NetWorkDays(Min(SBD), Max(SBD))

[antoniotiman]

Hi,

See Attachment.

Regards,

Antonio