topic Re: Button in QlikView

Button

Thu, 17 Sep 2015 11:21:34 GMT

Hi All,

Four buttons I have

All AMERICA EMEA APAC

when All is selected it should select AMERICA, EMEA, APAC
but if no data for EMEA and APAC, it should display AMERICA, instead if no value for either one region it is not selecting the All button

it should display AMERICA in All if no data for EMEA and APAC.

Can anyone help me on this?

Re: Button

marcus_sommer — Thu, 17 Sep 2015 11:30:59 GMT

Why don't using a simple listbox for this instead of four buttons with complex logics?

- Marcus

Re: Button

jonathandienst — Thu, 17 Sep 2015 11:39:45 GMT

Selecting nothing is the same as selecting All. This is the default QV behaviour. I agree with Marcus - why add complex logic for something which is already managed by QV?

Re: Button

Thu, 17 Sep 2015 12:43:44 GMT

ok agree with you and marcus, but how can i ge All field in my region, all should hav data for all three region. how do i calculate it?

Re: Button

marcus_sommer — Thu, 17 Sep 2015 12:49:04 GMT

For the most calculations like sum(value) or count(order) you don't need to worry - everything will be correct calculated to the available data.

- Marcus

Re: Button

Thu, 17 Sep 2015 12:53:05 GMT

actually i want to give field name as ALL if Region is america, apac and emea so finally i will have four fields in Region filter ALL,AMERICAS,APAC,EMEA, how can i acieve this?

Re: Button

marcus_sommer — Thu, 17 Sep 2015 13:12:30 GMT

Such matching should be done within the script - I think this will be really helpful for you:

Unbalanced, n-level hierarchies

- Marcus

Re: Button

Thu, 17 Sep 2015 13:25:26 GMT

How about this as an idea, have a list box displaying the regions, and have a button above that with an action behind it of 'Clear Selection - Region'. This gives users the ability to dissect data by region but also to select all regions. What do you think?

Re: Button

nagaiank — Thu, 17 Sep 2015 13:52:19 GMT

Create the following table and the list box on the lb_region field:

load * inline [

lb_region, region

AMERICAS, AMERICAS

APAC, APAC

EMEA, EMEA

ALL, AMERICAS

ALL, APAC

ALL, EMEA

];