topic Re: Regarding radio button in QlikView

Regarding radio button

Wed, 24 Jun 2009 16:00:47 GMT

Dear All,

Can anyone suggest me how to use radiobutton for a particlar chart in qlikview. As........................

if we have two option in radiobutton:1) Report 1 2) Report 2

If we select 'Report 1' from radiobutton then it will display chart no 1 and if we select 'Report 2' it will display chart no 2.

is there any macro or something else......................

Plz suggest me ASAP

Regarding radio button

Wed, 24 Jun 2009 17:10:33 GMT

Hi,

In Qlik View we don't have Radio Button. But you can make it using list box.

Steps 1:

Make List box and the load you fields and the go to Properties and then "Presentation" tab.

Then select "Selection Style Override" -->"LED"

Then Goto "Caption" --> un check the "Show Caption" Option.

Now your list box will look like "Radio Button".

Step 2:

Declare one variable in the qv document. in my sample i have created "GetShowValues"

Step 3:

Write the below Macro in your qv document.

Sub GetVal
Set Val=ActiveDocument.Fields("Name").GetSelectedValues
Val1 = Val.Item(0).Text
ActiveDocument.Variables("GetShowValues").SetContent Val1, True
End Sub

Step 4:

Goto "Setting" --> Document Properties-->Macro tab.

Then in the "Field Event Triggers" "Select your List box Filed"

Then in the right hand side select "OnSelect" event you can select the macro "GetVal"

Step 5:

Goto Chart1 Properties -->Layout--->Show Conditional -->

Give the =GetShowValues='Report1'.

Step 6:

Goto Chart2 Properties -->Layout--->Show Conditional -->

Give the =GetShowValues='Report2'.

Now according to your selection in the list box the chart will be displayed.

See the attached sample document.

Thanks

Saran.

Regarding radio button

Wed, 24 Jun 2009 17:28:41 GMT

Hi,

You can archive this with out using macro also.

Change the following settings in the chart Properties.

Chart 1: "Show Conditional" Put like this "=getfieldselections ( Name )='Report' "

Chart 2 :"Show Conditional" Put like this "=getfieldselections ( Name )='Repor2' "

This will also works.

Thanks

Saran.

Regarding radio button

johnw — Thu, 25 Jun 2009 00:18:42 GMT

You don't need a macro AND you don't need getfieldselections(). Just use =Name='Report1'.

Regarding radio button

Anonymous — Thu, 25 Jun 2009 03:33:07 GMT

If your priority is how it looks, then filed Name in style LED makes sense. If the exact presentation doesn't matter, you can use an input box with variable Name with predefined values Report 1 and Report 2, and with drop-down select. This way you don't need additional fields. All the rest is the same.

Regarding radio button

johnw — Thu, 25 Jun 2009 04:31:51 GMT

Is there an advantage to using a variable with two values instead of a field with two values? I've always preferred fields to variables, but I want to make sure I'm not missing something. Either approach works, of course.

Regarding radio button

Anonymous — Thu, 25 Jun 2009 05:23:40 GMT

John,
I prefer not to create unnecessry fields, if possible, to keep data model cleaner. And, the property "Always One Selected" which is necessary here for the field sometimes may disappear on reload. Nothing can happen to the variable. And you don't need to reload when you want to make a change.
The advantage is not that big, as I can tell. More like a matter of preference.

Regarding radio button

johnw — Thu, 25 Jun 2009 05:35:12 GMT

Good points, particularly regarding the reload. That's been trouble for me a few times when I was playing with my "not related to the real data" fields in some of my bigger applications. And while I think I've only lost my "always one selected" on one occasion, it seems like a pretty big problem for a lot of people.

Regarding radio button

Thu, 25 Jun 2009 13:32:07 GMT

Hi Saran,

I got ur test qv file and apply it at my original application

it will work thanks a lot for ur support

Neetu Singh

Re: Regarding radio button

userid128223 — Thu, 26 Jul 2012 16:28:55 GMT

what if you had to do exact same thing but show and hide data within a straight table. I have date 1 and date 2 as criteria.

1) i will create new inline table with 2 fields: date 1 and date 2

2) create listbox and turn it into checkbox, link it to newly created table field called Date1 & Date 2

How can I now show and hide within list box date1 data or date 2 data, based on above selection.

Re: Regarding radio button

Sat, 17 Nov 2012 18:37:44 GMT

Brilliant and very helpful post!

Re: Regarding radio button

Anonymous — Thu, 25 Jul 2013 18:17:04 GMT

I´m using LED style for selection on my list. The problem is that the labels are greater than the visible area, so the qlikview puts the char # in all list's options. How can i force the list to show all chars?

Thanks