topic Re: creating list box based on stright table expression in QlikView

creating list box based on stright table expression

Fri, 29 Aug 2014 12:39:18 GMT

Hi all,

I have already created stright table claims and it contains dimensinos like pol_no,claim_no and expressions like

incurred_amount=(setanalysis expression)

indicater(Y/N)-if(incurred_amount>100,'Y','N')

i need to create list box based on indicater(Y/N) if i click on 'Y' then it need show in stright table related 'Y' indictater.like that for 'N' also

but am trying in list box expression with (if(incurred_amount>100,'Y','N')) but it is showing nothing in as list box values.

can you any suggestion for that?

Re: creating list box based on stright table expression

Anonymous — Fri, 29 Aug 2014 12:49:04 GMT

qhy don't you use a Dropdown box within your straight table for indicater(Y/N). no other listbox is necessary.

your solution for the listbox has no connection to your datamodel. what do you expect? 2 lines (one Y, one N?)

I would try with an Inline Code,but with Connection in datamodel to other tables

Re: creating list box based on stright table expression

mvanlutterveld — Fri, 29 Aug 2014 12:55:27 GMT

Hi,

You can add an extra line in your script:

If(Incurred_amount > 100,’Y’,’N’) as YourField

And add this field as a list box to your app. This gives you more flexibility instead of using an expression in the list box. If you want to stick with using an expression to the list box try the following expression:

= If(Incurred_amount > 100,’Y’,’N’)

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:03:30 GMT

thanks for replay but it is not workinh when i write in expression

Re: creating list box based on stright table expression

mvanlutterveld — Fri, 29 Aug 2014 13:16:48 GMT

Strange. Can you provide me with a screenshot of your expression?

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:21:28 GMT

Can you post the qvw?

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:23:36 GMT

it have 300 MB file i can not post?

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:30:28 GMT

sorry i can't send any data

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:53:40 GMT

Hi Sanjeev,

Can you replace the incurred_value with the set expression in the IF statement?

eg: if(set expression>100,'Y','N')

Just try if this works, if not then maybe the problem could be there.

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 13:58:05 GMT

it is not working

Re: creating list box based on stright table expression

Fri, 29 Aug 2014 14:03:25 GMT

I think the problem is in the set expression then. It is not setting a value to the incurred_value field. Maybe if you post that we might be able to help you.