Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Check box does not appear

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

11 Replies
sushil353
Honored Contributor II

Re: Check box does not appear

r u using one selected value?

Not applicable

Re: Check box does not appear

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

Re: Check box does not appear

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

Re: Check box does not appear

itsangad,

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

Mitch

Not applicable

Re: Check box does not appear

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

Re: Check box does not appear

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
Honored Contributor II

Re: Check box does not appear

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

Re: Check box does not appear

Thank you Sushil,

I'll change my script and see what happens.

Mitch

Not applicable

Re: Check box does not appear

Sushil,

It worked perfectly, thanks again.

Mitch

Community Browser