topic Re: Set Analysis - Keep Parent Dimension in QlikView

Set Analysis - Keep Parent Dimension

Wed, 21 May 2014 15:08:05 GMT

Dear all, good morning.

I'm having some issues about creating a set analysis to keep the parent dimension when selected one specific field.

For example, when select BRAZIL in country the list, the table should keep all other countries for the same region.

I mean, when I select a country I want that the table understand that I select the whole Region, and not a specific country.Like image below:

Someone has a clue about it?

Thanks !!

LOAD * INLINE [

REGION, COUNTRY, VALUE

AMERICA, BRAZIL, 10

AMERICA, US, 20

EUROPE, ITALY, 30

EUROPE, ENGLAND, 15

ASIA, JAPAN, 12

ASIA, CHINA, 18

];

Re: Set Analysis - Keep Parent Dimension

arthur_dom — Wed, 21 May 2014 15:21:25 GMT

See the attached QV.

I used triggers on County Field !Dropbox - qv1.qvw

Re: Set Analysis - Keep Parent Dimension

Wed, 21 May 2014 15:24:37 GMT

Hi Fabio,

I don't how much this will be more complex in your real example, but using the inline table you provided, you can try something like this:

sum({$<REGION = P(REGION), COUNTRY=>} VALUE)

Re: Set Analysis - Keep Parent Dimension

arthur_dom — Wed, 21 May 2014 15:28:45 GMT

You can Add 2 triggers on Document Proprieties.

On COUNTRY the actions should be: Select in Field, choose field REGION and the value is =REGION, the second Action is Clean this field, choose COUNTRY. See attached files.

Re: Set Analysis - Keep Parent Dimension

Wed, 21 May 2014 15:29:03 GMT

That's it Jean-Pierre ...

Appreciate your help.