Split multivalues between categories?

HCL Domino Domino Forum
1

I need to split multivalues so that only the right one displays in a column, depending on the category it is displayed in the view.

It is a nice problem which has no solution In R5. I am looking for solutions, workaround or ideas on ND6 to solve this.

The document content is:

Field “Client” contains “A”:“B”

Field “Value” contains 1:2

Right now, because of Notes categorization, we can only have:

Category: A

…Value: 1,2

Category: B

…Value: 1,2

But, under the form’s logic, A is associated with 1 and B is associated with 2

So in the view we want:

Category: A

…Value: 1

Category: B

…Value: 2

Any idea how to achieve this??? I need to find some sort of a way to tell the column to display Value[0] or Value[1] depending on the value of the first categorized column. (who’s code is: “A”:“B”)

@GetViewInfo doesn’t seem to solve the problem. Any workaround, sort of splitting all the data into 2 forms?

TIA!

Nicolas Abesdris

Quintessence e-solutions Inc.

2

Subject: Split multivalues between categories?

Try making the column value

(Client + “\”) + Value

This should result in the correct categorization.

3

Subject: RE: Split multivalues between categories?

I know, I have thought of that solution.But we then get the following result:

Client: A

…Value 1

…Value: 1, 2

Client: A

…Value 2

…Value: 1, 2

The categorization is right, but the various values inside the column for the document itself continue to display all the multiple values, rather than showing 1 or 2 only.

See my other post in response to M Riggsby for more details about by problem.

Thanks!!

Nicolas Abesdris

Quinetssence e-solutions Inc.

4

Subject: RE: Split multivalues between categories?

That’s how it has to be. The value is itself essentially a category for these purposes, but you can, for cosmetic purpoes, remove the column that displays the value field.

5

Subject: *Exactly. You don’t need to display it again.

6

Subject: Split multivalues between categories?

I think there are some important details about the situation missing here. If value 1 is associated with category A and 2 with category B, why does a document with category A or category B have both 1 and 2 as values?

7

Subject: RE: Split multivalues between categories?

Well, to put you in full context, each document is a given project, with a detailed budget.But there is also 4 fields containing the percentage breakdown for each sponsor.

In most case we have sponsor1 = 100% but sometimes, you can have:

sponsor1 - 35%, sponsor2 - 65%, etc. up to 4 sponsor per project.

Now, I need to show all these budget numbers, categorized by sponsor, but with only their respective % of the budget:

Category: Sponsor

…project1: totalBudget * SponsorPercentage

…project2: totalBudget * SponsorPercentage

…

Category: Sponsor

…project1: totalBudget * SponsorPercentage

…project2: totalBudget * SponsorPercentage

…

And so on.

Except, on each document, we have 4 sponsor fields and 4 sponsor percetage.

Using the following code in the first column:

Sponsor1:Sponsor2:Sponsor3:Sponsor4

will correctly categorize all projects per sponsor, even if a project is sponsorized by several sponsor.

But the budget will still show the FULL budget, not each sponsor’s respective part. I can multiply it by the percentage, but WHICH percentage?? The category has grouped each value, but hese value might come from any of the 4 sponsor fields.

Any idea?

TIA

Nicolas Abesdris

Quintessence e-solutions Inc.

8

Subject: RE: Split multivalues between categories?

OK, I get it. It’s not that A maps to 1, but rather that the first entry in the category field has to be matched in some way with the first item in the values field, and so on. Ben’s got the right solution for this in his post.

9

Subject: RE: Split multivalues between categories?

Actually, perhaps I haven’t been clear about the deeper knot of the problem: it is not about categorizing, it is about displaying the right value in the columns INSIDE the given category.Such as:

Document1:

Sponsor1 = ClientA, percentage1 = 10%

Sponsor2 = ClientB, percentage2 = 90%

Budget = 10,000$

Document2:

Sponsor1 = ClientC, percentage1 = 40%

Sponsor2 = ClientA, percentage2 = 60%

Budget = 20,000$

And I want this result: (ideally… i wish!)

Category: ClientA

…project1: 10,000 * 10% = 1,000$

…project2: 20,000 * 60% = 12,000$

Category: ClientB

…project1: 10,000 * 90% = 9,000$

Category: ClientC

…project2: 20,000 * 40% = 8,000$

The $ amoutns must be in real column (not categorized) bceause they need to be summedup and the total should match the total budget.

But as you can see in my exemple, a client can be in any of the 4 fields, sponsor1 to sponsor4, and associated with a percentage in the respectivly matched percentage1 to percentage4 fields.

Honnestly I haven’t found any workaround so far, short of adding response documents uner each project for each sponsor, looking up all values and showing the responses documents in the view rather than the parent. An awfully complex workaround if you ask me!!

Any other idea?

TIA

Nicolas Abesdris

Quintessence e-solutions Inc.

10

Subject: RE: Split multivalues between categories?

Ah. Yes, that’s a much, much thornier problem. I’d probably solve it by either using response documents or throwing the whole mess at Excel.

11

Subject: Split multi-value between categories?

You’ll need multiple documents to do that in a view.

Any given document is only in a view’s index once, regardless of how many categories it’s displayed under.

Thus, the columns for a given document are only calculated once.

In short, you cannot have a document show different column values under different categories.

12

Subject: RE: Split multi-value between categories?

I know…I thought perhaps ND6 would have given me some additionnal tools to handkle that situation.

@GetViewInfo seemed to offer interesting possibilities; if indeed it would have allowed me to base an @If on teh real actual value of a view column…

but no, it doesn’t work in that context.

Oh well…

I’ll present the structure redresign option to my client and we will see what he prefers…

TIA

Nicolas Abesdris

Quintessence e-solutions Inc.