Want object to be visible is only one row is selected on other object

[#1]

I have a chart (Actuarial vs SICS) that shows rows of data for a lot of different accounts.  I created another chart (Account) that shows more detail.  I would like Account to appear only if the user has selected a single row from Actuarial vs SICS.  I see that there is some in the presentation tab that might allow me to make this happen.

I have 2 questions. 

1. How do I do this?
2. I display the Current Selections object.  However when I select a single row in Actuarial vs SICS, the Current Selections object seems to show that I've selected mulitple Unique IDs, even though I think I've selected only one.  Unique ID is the field that links two data files.

Can anyone help me with this?

Mitch

[fdelacal · Accepted solution]

see atach

i use conditional

GetPossibleCount([Unique ID])=1

hope that helps you

[#3]

Thank you!  That works.  Do you know why the information in "Current Selections" seems to indicate that more than one unique ID is selected?

Mitch

[fdelacal]

i only see only one value.
can you add a picture?

[#5]

I had trouble finding a good example on the test data that I uploaded.  Select DLHSLWLOLJ in the Actuarial vs SICS object.  This will show what I'm confused about.

[kaushiknsolanki]

Hi,

     The reason is that you have created a Business ID from Unique_ID with some left..... expression. Meaning its a calculated field.

     Now see in the example you have given for DLHSLWLOLJ. You got this business id from two unique id, and thus when you select this business id, you see two unique id in current selection, because this id is generated from this two unique id's.

     You can create the business id in script like this.

LOAD

[Unique ID],

  Left([Unique ID],Index([Unique ID],'_')-1) as BUSINESS_ID,

     [Underwriter bookings],

     [Type of Business],

     [Business ID bookings],

     [Booking Year and Month],

     [Booking Year],

     [Booking Month],

     [Main Class],

     [AC 3],

     ASL,

     Class,

     [TOP method],

     [TOP Method All],

     Section,

     [Payment Partner],

     [Payment Partner Code],

     [Responsible Partner],

     [Responsible Partner Code],

     Commissions,

     [Earned Premium],

     [Gross Premiums],

     Loss,

     [Loss Expense],

     [Override Commissions],

     [Profit Commission],

     [Total Loss Reserves],

     [Tot U/W Exp & Sundry],

     [Unearned Premium Reserve],

     [Actuarial Line Code],

     [Actuarial Line Name]

FROM

J:\Users\MKaplan\My Documents\_System Projects\Warehouse\Excel files\Sanitized\ProductionData.xlsm

(ooxml, embedded labels, table is BookingData);

And then use it in chart, so that you dont find any multiple records in current selection.

Hope this is clear.

Regards,

Kaushik solanki

[#7]

Hi Kaushik,

Thanks for the answer.  The reason I'm confused is because the calculation merely removes the data that you see after the underscore.  Thus the only row I'm selecting is the one with a single Unique ID, based on the U/W Year selection (in its ListBox).

I can certainly go ahead and create the Business ID during the import.  I haven't yet tried that, but even if it does work, I'm still confused about how selections in the Actuarial vs SICS object are interpreted.

Mitch