Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anil_Babu_Samineni

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
Master III
Master III

Hi,

See Attachment.

Regards,

Antonio