topic Re: Re: separate Checkbox for each value in QlikView

separate Checkbox for each value

Mon, 05 May 2014 07:51:38 GMT

I have field YEAR,

I want to create a separate check box for each value in the YEAR.

Example 2014, 2013, 2012

I tried the following

I created a list box and override the style to check box, removed the caption and the field was expression which gives me one value

= if (YEAR=2014,2014) this example suppose that I already know all values.

I crated anther one for 2013

now I have 2 check boxes

the problem if I select 2014, then select 2013 the first selection 2014 unselected automatically.

I can't make both selection for 2013 and 2014.

Any idea for better approch for my needs

Re: separate Checkbox for each value

jagan — Mon, 05 May 2014 08:16:59 GMT

Hi,

Why you are trying to create separate list box for each value in the YEAR field, you can create one list box with all the years and then change style to Check Box.

Regards,

jagan.

Re: separate Checkbox for each value

Mon, 05 May 2014 08:25:57 GMT

for design purpose,

Re: separate Checkbox for each value

its_anandrjs — Mon, 05 May 2014 08:28:45 GMT

You can use list box of year as the LED Check boxes

Go to list properties >> Image Options >> Selection Style Override >> and select LED or LED Check boxes.

Re: separate Checkbox for each value

Mon, 05 May 2014 08:29:55 GMT

I don't want a list of check box, I want each checkbook separate

Re: Re: separate Checkbox for each value

Mon, 05 May 2014 08:35:11 GMT

Will this design do for you?

Above can be achieved by unchecking Single Column check in Presentation tab of list box.

Making as separate list boxes will complicate the logic.

Let me know ur comments.

Thanks,

Prabhu

Re: separate Checkbox for each value

SunilChauhan — Mon, 05 May 2014 08:42:41 GMT

use comperative analysis available in qv 11

there you can mange to create seperate group and they not effect each other and you can select both at a time

hope this helps

Re: separate Checkbox for each value

Mon, 05 May 2014 09:13:35 GMT

Thanx,

After applying the solution I got an error.

In the list I chosed expression to add the follwoing

=Year & '(' & count(DBID) & ')'

but this is not working

What I want is as to show each year and the count of records for each year beside

somthing like 2014(1000) 2013(500)