topic Re: Dynamic field in a checkbox in QlikView

Dynamic field in a checkbox

Anonymous — Mon, 16 Mar 2015 12:18:21 GMT

Hi,

I'd like to change a field in a Checkbox dynamicly. Actually, my task is to switch between Field1 (Brands) and Field2 (Advertiser). So, I base my Dynamic Checkbox on the following expression: =if ($(vChoice)=1, Brands, if ($(vChoice)=2, Advertiser)). It allows me to control the content of the Dynamic Checkbox by the value =1 or 2.

But it doen't wok properly. For instance:

Step 1: I set vChoice=1 and show Brands in the Dynamic Checkbox

Step 2: I select a brand, e.g. AUDI

Result: I see that not only brand AUDI but also some advertisers were selected. Why? Advertisers should not get selected if I select brands only.

Could you please say how I can set it so that brands and advertisers were selected seperately.

Please, see the file attached.

Larisa Filonova

Re: Dynamic field in a checkbox

sunny_talwar — Mon, 16 Mar 2015 12:33:27 GMT

your two tables are linked to each other on the field name Media. If you don't want selection of Brand to not impact Advertisers and vice versa you will have to break that link. You can try something like this may be:

brand_table:

LOAD [Media type] as [Media],

[Brand] as [Brands],

[Cost RUB] as [Budget]

FROM

brand_data.xlsx

(ooxml, embedded labels, table is Лист1);

advertiser_table:

LOAD [Media type] as [Media1],

Advertiser,

[Cost RUB] as [Budget1]

FROM

advertiser_data.xlsx

(ooxml, embedded labels, table is Лист1);

in one of the tables call media type as Media1.

I haven't tested it, but I am almost certain this will help.

Best,

Re: Dynamic field in a checkbox

Anonymous — Mon, 16 Mar 2015 13:07:46 GMT

The point is that I want Media to be a common field, that's why I don't want to rename it.

Let's imagine that two tables (brand_table and advertiser_table) must have a common field Media.

Then:

I see that it can work correctly in case of static checkboxes even if there is a common field.

Scenario 1:

Step 1: I create two static checkboxes (the first one is based on Brands field, the seconds one is based on Advertiser field)

Step 2: I select a brand and make sure that no advertiser has been simultaneously selected. That's right.

Scenario 2:

Step 1: I create a dynamic checkbox by the means of the following expression =if ($(vChoice)=1, Brands, if ($(vChoice)=2, Advertiser)).

Step 2: I select a brand in the dynamic checkbox and see that some advertisers have been simultaneously selected. That's wrong!

Maybe, I should set a dynamic checkbox not by the means of if statement but somehow differently?

See the file attached.

Re: Dynamic field in a checkbox

sunny_talwar — Mon, 16 Mar 2015 13:17:05 GMT

I get your point now. Let me see if I can figure that out.

Best,

Re: Dynamic field in a checkbox

buzzy996 — Mon, 16 Mar 2015 14:09:33 GMT

try this way,

dimensionNo	dimensionLabel	dimension
1	Customer Name	[Customer Name]
2	Province	Province
3	Region	Region
4	Customer Segment	[Customer Segment]
5	Product Category	[Product Category]

2. and use the folowing expression from ur UI,

Dimension info-

Used dimensions

=$(=only({$ <_dimensionNo={1}>} _dimension))

Enable Conditions

=SubStringCount(Concat(_dimension, '|'), '$(=only({$ <_dimensionNo={1}>} _dimension))')

Look might be complex,but it's very simple way to do,

create list box with _dimensionLabel,all ur fields are available.. slecte ur field dynamically from here,it will add auto matically to ur table.

Re: Dynamic field in a checkbox

buzzy996 — Mon, 16 Mar 2015 14:20:04 GMT

TRY THIS,

THIS WILL WORK WITH VERSION 11 ON WORDS,

PLS ADD THESE CONDIONS ON UR DIMENSION TAB

Used dimensions

=$(=only({$ <dimensionNo={1}>} dimension))

Enable Conditions

=SubStringCount(Concat(dimension, '|'), '$(=only({$ <dimensionNo={1}>} dimension))')

Creat list box with dimesnionlable and presentation tab selection style over ride as LED check box.

Try to slect any brand from list box those changes we can see from ur chart object.

Re: Dynamic field in a checkbox

jonathandienst — Mon, 16 Mar 2015 14:33:08 GMT

No need to change your data model. Just do the following:

Create variable vDynamic
Change first button first action to change vDynamic to Brands
Change second button first action to change vDynamic to Advertiser
Change the dynamic list box expression to $(vDynamic)

See attached.

HTH

Jonathan

Re: Dynamic field in a checkbox

Anonymous — Mon, 16 Mar 2015 15:39:31 GMT

I've got it. Thank you!