creating list box based on stright table expression

[#1]

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?

[Anonymous]

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

[mvanlutterveld]

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’)

[#4]

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

[mvanlutterveld]

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

[#6]

Can you post the qvw?

[#7]

it have 300 MB file i can not post?

[#8]

sorry i can't send any data

[#9]

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.

[#10]

it is not working