Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Group fields into one field in dashboard

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

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

Re: Group fields into one field in dashboard

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 ??

Re: Group fields into one field in dashboard

yes


talk is cheap, supply exceeds demand
Community Browser