topic Re: Group fields into one field in dashboard in QlikView

Group fields into one field in dashboard

Wed, 03 Feb 2016 09:39:28 GMT

Hello,

In my DATAMART FINANCE, I need to visualize many fields into one field.

I have Dimension of Accounts:

- ID_COMPTE

-COMPTE : (for exemple : 712111)

- CODE CATEGORIE 1: ( 7 )

-CODE CATEGORIE 2: ( 71 )

-CODE CATEGORIE 3: ( 712 )

-CODE CATEGORIE 4 : ( 7121)

Id_compte	compte	CODE CATEGORIE 1	CODE CATEGORIE 2	CODE CATEGORIE 3	CODE CATEGORIE 4
1	712111	7	71	712	7121
2	712220	7	71	712	7122
3	714320	7	71	714	7143

I need to visualize the revenu by all the " CODE CATEGORIE " but in the same field, i'd like to have a report like this:

	Revenu
7	10000
71	1000
712	100
71211	10
712111	1

Can anybody tell me if its possible or not ?

Thank you.

Re: Group fields into one field in dashboard

swuehl — Wed, 03 Feb 2016 19:11:09 GMT

Not really sure what you are trying to achieve. It somehow looks like your code category fields build a hierarchy and you want to show partial sums?

Then just create a pivot table chart with all account dimension fields as dimensions, as expression something like

=Sum( RevenuField)

Then go to presentation tab an enable partial sums for all your dimensions, or for the one you want to show partial sums.

Re: Group fields into one field in dashboard

Gysbert_Wassenaar — Wed, 03 Feb 2016 19:13:46 GMT

Create a new table with a new field:

CategorieHierarchy:

CrossTable(Dummy, [CODE CATEGORIE],2)

LOAD

ID_COMPTE,

COMPTE,

[CODE CATEGORIE 1],

[CODE CATEGORIE 2],

[CODE CATEGORIE 3],

[CODE CATEGORIE 4]

FROM

[Dimension of Accounts]

;

DROP FIELD Dummy

The use the new field CODE CATEGORIE as chart dimension.

Re: Group fields into one field in dashboard

Thu, 04 Feb 2016 09:26:21 GMT

Thank you all for your answers.

swuehl what im trying to achieve is to have in the same fields in the report different hierarchy, whithout having all the details . for exemple id like to pick value 7 from code category 1 (which group many values of other code categories) and just the value 714 from code category 3;

	Revenu
7	1000
714	10

gwassenaar

Do you mean create field that contains all the codes categories ??

Re: Group fields into one field in dashboard

Gysbert_Wassenaar — Thu, 04 Feb 2016 17:29:31 GMT

yes