Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

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.

Database:

   

SBD# of DaysWeek
03/08/20171W31
05/08/20171W31
05/08/20171W31
03/08/20171W31
04/08/20171W31
04/08/20171W31
07/08/20171W32
10/08/20171W32
10/08/20171W32
10/08/20171W32
08/08/20171W32
19/08/20175W33

Requirement:

    

WeekStart DateEnd Date# of days
W3103/08/201705/08/20173
W3207/08/201710/08/20173
W3314/08/201719/08/20175
2 Replies

Re: 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.

May be this?

Week as Dimension

Expressions are

1) Min(SBD)

2) Max(SBD)

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
antoniotiman
Honored Contributor III

Re: 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.

Hi,

See Attachment.

Regards,

Antonio