Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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’)
thanks for replay but it is not workinh when i write in expression
Strange. Can you provide me with a screenshot of your expression?
Can you post the qvw?
it have 300 MB file i can not post?
sorry i can't send any data
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.
it is not working