Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Check box does not appear

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

1 Solution

Accepted Solutions
sushil353
Master II
Master II

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

View solution in original post

11 Replies
sushil353
Master II
Master II

r u using one selected value?

Not applicable
Author

Hello,

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

Year.jpg

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

Thanks,

itsangad

Not applicable
Author

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.

Not applicable
Author

itsangad,

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

Mitch

Not applicable
Author

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

Not applicable
Author

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
Master II
Master II

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

Not applicable
Author

Thank you Sushil,

I'll change my script and see what happens.

Mitch

Not applicable
Author

Sushil,

It worked perfectly, thanks again.

Mitch