Check box does not appear

[#1]

I have a ListBox with the field as a calculated expression: Year([Effective Date])

I want the box to allow the user to select by year, not the specific data.  Anyway, my problem is that the check doesn't appear in the Windows Checkbox next to the selection.  The box goes white, but no check appears.  Similarly if I use the LED option, the box goes white, but not green!  It works okay for all of my other ListBoxes, but this is the only one with a calculated value.  Any suggestions to get the check to appear? (or the green).

[sushil353]

r u using one selected value?

[#3]

Hello,

I think it should work, it is nothing to do with calculation. Though I tried it, and it works fine for me.

Can you please share your qvw, to look into this.

Thanks,

itsangad

[#4]

I'm not sure what you're asking.  The total list contains 9 years.  The user can select one or more.  Selecting one year for example will be selecting all of the data that has an effective date (insurance policies) in that year.  Whether the user selects one or more years, the "x" or green color doesn't appear.  The only thing that happens is that the box becomes white.  Or, if I sort by state, the selections move to the top.

[#5]

itsangad,

I'm kind of new to this.  How do I get my qvw to you?

Mitch

[#6]

Hello Mitch,

In the editor, at the upper right corner, you would see, "Use advanced editor" link, click on that and then you can upload your qvw.

Thanks,

itangad

[#7]

Hi itangad,

I've attached a "sanitized" version of my qvw.  I'm not permitted to release actual company data.  I left in enough detail so that it behaves the same way as the one I'm actually working with.  Also thanks for letting me know how to upload the file!

Mitch

[sushil353 · Accepted solution]

Hello,

problem is with your data association.. if you want to have the year field in your report.. then try this:

1. make year field in script level itself and use that field in report..

2. use year_field in your report instead of =Year([Effective Date])

Directory;

LOAD [Unique ID],

     [Business ID info],

Year([Effective Date]) as year_field,

[Effective Date],

     [Business Title],

     [Level of Business (Code)],

     [Type of Business (Code)],

     [Base Company],

     EPI

FROM

[..\txt exports from BO\Sanitized\BusinessInfo.xlsx]

(ooxml, embedded labels, table is BusinessInfo);

HTH

Sushil

[#9]

Thank you Sushil,

I'll change my script and see what happens.

Mitch

[#10]

Sushil,

It worked perfectly, thanks again.

Mitch