topic Re: Enable Conditional? in QlikView

Enable Conditional?

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

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

Re: Enable Conditional?

sunny_talwar — Tue, 09 Jan 2018 12:31:25 GMT

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

Re: Enable Conditional?

bobbydave — Tue, 09 Jan 2018 13:29:13 GMT

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?

Re: Enable Conditional?

sunny_talwar — Tue, 09 Jan 2018 13:36:12 GMT

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

Re: Enable Conditional?

bobbydave — Tue, 09 Jan 2018 13:46:28 GMT

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

Re: Enable Conditional?

bobbydave — Tue, 09 Jan 2018 13:56:49 GMT

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.

Re: Enable Conditional?

Anonymous — Tue, 09 Jan 2018 16:23:45 GMT

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?

Re: Enable Conditional?

Peter_Cammaert — Tue, 09 Jan 2018 16:45:46 GMT

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

Re: Enable Conditional?

bobbydave — Fri, 12 Jan 2018 11:05:50 GMT

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

Re: Enable Conditional?

bobbydave — Fri, 12 Jan 2018 11:06:52 GMT

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

Re: Enable Conditional?

bobbydave — Fri, 12 Jan 2018 11:11:06 GMT

Attached a pic i am trying to achieve.

Re: Enable Conditional?

bobbydave — Fri, 12 Jan 2018 11:11:39 GMT

Attached a pic i am trying to achieve.

Re: Enable Conditional?

bobbydave — Fri, 12 Jan 2018 11:12:09 GMT

Attached a pic i am trying to achieve.