topic Re: Check box does not appear in QlikView

Check box does not appear

Fri, 15 Mar 2013 15:59:40 GMT

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

Re: Check box does not appear

sushil353 — Fri, 15 Mar 2013 16:10:37 GMT

r u using one selected value?

Re: Check box does not appear

Fri, 15 Mar 2013 17:03:32 GMT

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

Re: Check box does not appear

Fri, 15 Mar 2013 17:05:15 GMT

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.

Re: Check box does not appear

Fri, 15 Mar 2013 20:45:07 GMT

itsangad,

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

Mitch

Re: Check box does not appear

Mon, 18 Mar 2013 05:48:10 GMT

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

Re: Check box does not appear

Mon, 18 Mar 2013 14:00:06 GMT

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

Re: Check box does not appear

sushil353 — Mon, 18 Mar 2013 15:24:50 GMT

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

Re: Check box does not appear

Mon, 18 Mar 2013 15:38:10 GMT

Thank you Sushil,

I'll change my script and see what happens.

Mitch

Re: Check box does not appear

Mon, 18 Mar 2013 15:44:39 GMT

Sushil,

It worked perfectly, thanks again.

Mitch

Re: Check box does not appear

sushil353 — Mon, 18 Mar 2013 15:46:29 GMT

Welcome!!

Re: Check box does not appear

Tue, 19 Mar 2013 10:03:37 GMT

Hello Mitch,

Sorry was delayed response was little busy with some assignments, I am glad that you got response from the community.

thanks,

itsangad