Straight Table issue

[chrisevans_cj]

Good day,

Looking for some assistance with a straight table.

I want to see the data as ResourceName, DayOfWeek (Mon-Fri), Week1, Week2, Week3, etc

Which should be grouped together by the week and DayOfWeek, and display the name of Client under Week1, Week2, Week3

E.G.

Resource          Day     Week1     Week2     Week3

Consultant1     Mon     ClientA     ClientB     ClientC

Consultant1     Tues     ClientA     ClientB     ClientC

Consultant1     Wed     ClientA     ClientB     ClientC

Consultant1     Thu     ClientA     ClientB     ClientC

Consultant1     Fri     ClientA     ClientB     ClientC

Consultant2     Mon     ClientA     ClientB     ClientC

Consultant2     Tues     ClientA     ClientB     ClientC

Consultant2     Wed     ClientA     ClientB     ClientC

Consultant2     Thu     ClientA     ClientB     ClientC

Consultant2     Fri     ClientA     ClientB     ClientC

Data is a simple:

ResourceName     Client     StartDate     EndDate

Any suggestions on how to view this will be appreciated. Currently using a straight table with Resource, DateOfWeek, Client(hidden) as dimensions and the following Expressions

=IF(ReferenceWeek=sum(vvWeek),Client)

=IF(ReferenceWeek=sum(vvWeek+1),Client)

And vvWeek referes to: =NUM(WEEK(WEEKSTART(TODAY())))

[Anonymous]

Hi Chris,

Something like this?

[sunny_talwar]

Would you be able to share the raw data that is driving the above output? Without having an insight into the raw data, it would be difficult to know what needs to be done in order to get you to what is required

QlikCommunity Tip: How to get answers to your post?‌

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[chrisevans_cj]

Hi Fernando - I'm looking for something like this

[chrisevans_cj]

The sample of the raw data. You will see that a consultant can be at various clients during the week.

[chrisevans_cj]

I've added a sample of the data to the main post