Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rafael5958
New Contributor III

dynamic table (tabela dinamica)

I have a table in Excel that is something like this:

Position Name Value Line Expense

1 Joao Vale 100

2 Joao Trans 20

3 B C Paul Valley 400

4 Carlos Trans X 20

5 B Y Pedro Valley 400

I want to make a dynamic table that expand the office, then the name, Expense and put the total at the end. How do I do that ??? Something like:

The Joao Vale 100

                       behind 20

                        total: 120

        ----------------------------

        Charles X trans 20

                                total 20

----------------------------------------

B Paul Vale C 400

                            Total 400

      --------------------------------------

      Prdro Y Valley 400

                   Total 400

Translated with Google Translate - Qlik Community Administrative Team

Tenho uma tabela no excel que é mais ou menos assim:

Linha Cargo     Nome         Despesa     Valor

1        A          Joao A        Vale          100

2        A          Joao A       Trans          20                                      

3        B        Paulo C       Vale            400

4        A          Carlos X       Trans          20                                      

5        B        Pedro Y       Vale            400

Quero fazer uma tabela dinamica que expanda O cargo, depois o Nome, Despesa e coloque o total no final. Como faço isso??? Algo tipo:

A     Joao A     Vale   100

                      tras    20

                       total: 120

       ----------------------------

       Carlos X     trans 20

                               total 20

----------------------------------------

B   Paulo C     Vale   400

                           total 400

     --------------------------------------

     Prdro Y   Vale   400

                  total 400

Tags (1)
1 Solution

Accepted Solutions

Re: tabela dinamica

Hi,

Do you want like the below?

172780.JPG

Script:

Table:

LOAD * INLINE [

    Linha, Cargo, Nome, Despesa, Valor

    1, A, Joao A, Vale, 100

    2, A, Joao A, Trans, 20

    3, B, Paulo C, Vale, 400

    4, A, Carlos X, Trans, 20

    5, B, Pedro Y, Vale, 400

];

Create the Pivot table.

Add the dimension like the below

2.JPG

In the Expression

3.JPG

in the presentation

4.JPG

Hope this helps.

3 Replies
Not applicable

Re: tabela dinamica

Please post on English

Re: tabela dinamica

Hi,

Do you want like the below?

172780.JPG

Script:

Table:

LOAD * INLINE [

    Linha, Cargo, Nome, Despesa, Valor

    1, A, Joao A, Vale, 100

    2, A, Joao A, Trans, 20

    3, B, Paulo C, Vale, 400

    4, A, Carlos X, Trans, 20

    5, B, Pedro Y, Vale, 400

];

Create the Pivot table.

Add the dimension like the below

2.JPG

In the Expression

3.JPG

in the presentation

4.JPG

Hope this helps.

rafael5958
New Contributor III

Re: tabela dinamica

Thats it, thank you settu_periasamy.

Community Browser