Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group fields into one field in dashboard

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_comptecompteCODE CATEGORIE 1CODE CATEGORIE 2CODE CATEGORIE 3CODE CATEGORIE 4
17121117717127121
27122207717127122
37143207717147143


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
710000
711000
712100
7121110
7121111

Can anybody tell me if its possible or not  ?

Thank you.

4 Replies
swuehl
MVP
MVP

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.

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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
71000
71410

gwassenaar


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

Gysbert_Wassenaar

yes


talk is cheap, supply exceeds demand