I have already created stright table claims and it contains dimensinos like pol_no,claim_no and expressions like
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?
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
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’)
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.