Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to do this?

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

or

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

Tags (1)
4 Replies
Highlighted

Re: How to do this?

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

Highlighted
Creator III
Creator III

Re: How to do this?

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

Highlighted

Re: How to do this?

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

Highlighted
Creator III
Creator III

Re: How to do this?

i did and replied to the posts