Enable Conditional?

[bobbydave]

I am not sure if the way to go is Enable Conditional but....

I have a Case Type object

Case Type

CCIN

WFIN

CFIN

each of these case types will have expressions associated.

Completed  CFIN < 5 Days

Completed CFIN <=10 Days

Completed CFIN>10 Days

Completed  CCIN < 5 Days

Completed CCIN <=10 Days

Completed CCIN>10 Days

Completed  WFIN < 5 Days

Completed WFIN <=10 Days

Completed WFIN>10 Days

So my predicament is ....

When I select a case type, I want one list box called Days to have

< 5 days

<=10 days

>10 days

so if i select the Case Type listbox to show 'CCIN', the related Completed CCIN appears.

I'm assuming what i want to do relates to Enabling Conditional as I need to provide for WFIN and CFIN?

I really hope I have explained what i want

[sunny_talwar]

Would you be able to support your description with some raw data and expected output from it?

[bobbydave]

Hi Sunny,

I've attached my current selection.

My Case Type is CCIN so the corresponding expressions would be

Completed CCIN <5 days

Completed CCIN <=10 days

Completed CCIN > 10 days

but if I selected Case Type as CFIN, the corresponding expressions would be

Completed CCIN <5 days

Completed CCIN <=10 days

Completed CCIN > 10 days

but i then want those expressions to show be seen in a listbox only as

< 5 days

<= 10 days

> 10 days.

Does this make sense?

[sunny_talwar]

Not really... but I hope someone else might be able to make sense out of it and is able to offer help

[bobbydave]

I've got expressions:

Completed CCIN <5 days

Completed CCIN <=10 days

Completed CCIN > 10 days

which relate to when Case_Type = 'CCIN'

I've also got expressions:

Completed CFIN <5 days

Completed CFIN <=10 days

Completed CFIN > 10 days

which relate to when Case_Type ='CFIN'

As you can see from the expressions, they have <5 days, <=10 days and >10 days.

What I want to do is create a listbox of

< 5 days

<=10 days

>10 days

so depending on which case_type was selected which for arguments sake was CCIN,

i would use the listbox to select

< 5 days

<=10 days

>10 days

and the

Completed CCIN <5 days

Completed CCIN <=10 days

Completed CCIN > 10 days

would appear but as text

< 5 days

<=10 days

>10 days

Alternatively, if i was to chose Case_Type = 'CFIN, the corresponding

Completed CFIN <5 days

Completed CFIN <=10 days

Completed CFIN > 10 days

would appear but as text

< 5 days

<=10 days

>10 days

[bobbydave]

I've tried creating a listbox

=if([Completed CCIN <= 5 Days] and Case_Measures.CaseType = 'CCIN', '<5 Days',

if([Completed CCIN <= 10 Days] and Case_Measures.CaseType = 'CCIN', '<10 Days',

  if([Completed CCIN > 10 Days] and Case_Measures.CaseType = 'CCIN', '>10 Days',

   if([Completed CFIN <= 5 Days] and Case_Measures.CaseType = 'CFIN', '<5 Days',

    if([Completed CFIN <= 10 Days] and Case_Measures.CaseType = 'CFIN', '<10 Days',

      if([Completed CFIN > 10 Days] and Case_Measures.CaseType = 'CFIN', '>10 Days'

      ))))))

and even though

<5 days

<=10 days

>10 days

appear in my listbox, when i click on them, they deselect themselves. I understand why as a result of the duplication. I just dont know how to get around it.

[Anonymous]

Are you able to send over the data structure and a print screen of the actual interface so it is easier to visualise the end goal?

[Peter_Cammaert]

I assume your Case records in your data model have fields like [Date Started], [Date Completed] ans [Case Type]. If you add a field [Resolution Delay] to your data in your load script that assigns all closed cases to one of three categories (represented by thos text strings), wouldn't that solve the issues you have?

You could use an expression like

CaseData:

NOCONCATENATE

LOAD [Case ID],

     [Case Type],

     [Case Start Date],

     [Case End Date],

     :

     Pick(Match(true(), [Case End Date]-[Case Start Date]<5,

                        [Case End Date]-[Case Start Date]<=10,

                        [Case End Date]-[Case Start Date]>10),

                '< 5 days', '<= 10 days', '> 10 days') AS [Case Resolution Category],

     :

RESIDENT TempCaseData;

If your Case data also contains open cases, you should add a test and default value for those because for those cases [Case End Date] will probably still be empty.

Best,

Peter

[bobbydave]

I've attached a word document so you can see what i am doing

[bobbydave]

I've attached a word document so you can see what i am trying to achieve.