Hide/remove UnAssociated Value, keep Associated values like checkbox

Wed, 22 Jul 2015 08:02:26 GMT

Hi,

I got a Dashboard to be displayed for different Countries, with dynamic KPI's to be displayed in Chart.

Sample Data:

Country Projections Sales

India Proj_10 1000

India Proj_20 2000

US Proj_10 5000

India Proj_40 6000

India Proj_50 7000

Please note: Projection Fields can be different for country wise.

Requirement:

1. Allow only one country value to be selected.

2. For selected country display ONLY associated or relevant Projection values. Remove unassociated values from Projection List box.

3. The Projection list box values to have the functionality like checkbox so that only one Projection value is selected at a time.

Used List box for Country and Projections.Country List box enabled 'Always one selected value'.

First issue:

(Is there a way we can remove unassociated values from the List box )

Projections List box,shows associated value(Proj_10,Proj_20), but unassociated values are shown in Grey color.

Is there a way we can remove unassociated values from the Projection List box. Option 'Hide Excluded values' is not helping here as still grey color remains.

Second issue:

For Country India, Associated values of Projection List box is Proj_10,Proj_20. When I select one value say Proj_10 obviously the other Proj_20 disappears in the list box. Rather I would like to have this as checkbox. Have set it up using LED Checkboxes under style.

Hence good thing is I could select Proj_10 or Proj_20 or even both and both appears because of checkboxes.

BUT again we would need only one value to be selected in this Projection list box..When 'Always one selected value' and say currently the value is Proj_10 selected, now I could not change the Country list box to US.

Thanks in advance.

Regards,

Avin

Re: Hide/remove UnAssociated Value, keep Associated values like checkbox

Thu, 23 Jul 2015 03:01:53 GMT

Hi,

Any suggestion to approach these 2 issues mentioned in my post.

Thanks,

Avin

topic Re: Hide/remove UnAssociated Value, keep Associated values like checkbox in QlikView

Hide/remove UnAssociated Value, keep Associated values like checkbox

Re: Hide/remove UnAssociated Value, keep Associated values like checkbox