topic Straight Table issue in QlikView

Straight Table issue

chrisevans_cj — Wed, 25 Nov 2020 16:16:04 GMT

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())))

Re: Straight Table issue

Anonymous — Fri, 29 Jul 2016 13:18:34 GMT

Hi Chris,

Something like this?

Re: Straight Table issue

sunny_talwar — Sun, 31 Jul 2016 19:05:40 GMT

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

Re: Straight Table issue

chrisevans_cj — Mon, 01 Aug 2016 07:34:41 GMT

Hi Fernando - I'm looking for something like this

Re: Straight Table issue

chrisevans_cj — Mon, 01 Aug 2016 07:40:05 GMT

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

Re: Straight Table issue

chrisevans_cj — Mon, 01 Aug 2016 07:40:31 GMT

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