QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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?

Script:

```Table:
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

In the Expression

in the presentation

Hope this helps.

3 Replies
Not applicable

Re: tabela dinamica

Hi,

Do you want like the below?

Script:

```Table:
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

In the Expression

in the presentation

Hope this helps.

New Contributor III

Re: tabela dinamica

Thats it, thank you settu_periasamy.