topic Re: How to do this? in QlikView

How to do this?

bobbydave — Fri, 12 Jan 2018 14:19:04 GMT

I have a table (instructions attached).

When I click on Case Type = 'CFIN',

a listbox will have the values:

So my listbox will have Case Types

CCIN

CFIN

When I click on either,

CFIN

CCIN,

another text box will have

< 5 days,

<=10 days and

>10 days

This is just text.

CFIN has an 3 expressions

CFIN < 5 days

CFIN <= 10 days

CFIN > 10 days

When I click on CFIN in the listbox, i want

< 5 days,

<=10 days and

>10 days

to evaluate to

CFIN < 5 days

CFIN <= 10 days

CFIN > 10 days

so I'm assuming

pick(match(CFIN < 5 days,CFIN <= 10 days,CFIN > 10 days), ''< 5 days', '<=10 days', '>10 days') as mySelectedValue

doesnt work however.

If I select CCIN from CaseType, I expect to see 'CCIN <5 days', 'CCIN <= 10 days' and 'CCIN > 10 days' which would appear as

< 5 days

<= 10 days

> 10 days

So in other words, the outcome listbox will have

< 5 days.

<=10 days

> 10 days

for which ever Case Type is selected but they will correspond to different expression CCIN < 5 days and CFIN < < 5 days would appear in the list box as '< 5 days'

Attached visual

Re: How to do this?

Peter_Cammaert — Fri, 12 Jan 2018 14:26:22 GMT

This seems like the same question as your other discussion: Enable Conditional?

Re: How to do this?

bobbydave — Fri, 12 Jan 2018 14:29:15 GMT

It is but i am trying to explain myself better than the 'Enable Conditional' thread.

Re: How to do this?

Peter_Cammaert — Fri, 12 Jan 2018 14:32:27 GMT

You could have amended your question in your other post instead of leaving it "in limbo".

Re: How to do this?

bobbydave — Fri, 12 Jan 2018 14:35:42 GMT

i did and replied to the posts