topic Re: Contracted Table in QlikView

Contracted Table

Anonymous — Thu, 14 May 2015 14:22:27 GMT

Hy, I have a table:

Month Day Value

1 1 12

1 2 23

1 3 15

1 4 20

1 5 30

When I Contracted the field day the values are add, for example:

Month Value

1 + 100

All the values are add.

When I contracted the table, I want to pick the last value only, for example:

Month Value

1 30

Can you help me??

Thanks a lot.

Re: Contracted Table

Clever_Anjos — Thu, 14 May 2015 14:42:35 GMT

Are you using a pivot table, I guess

Whats your expression for "Value"?

Maybe

FIRSTSORTEDVALUE(

AGGR(

SUM(Value),

Month, Day

-(Month*100+Day)

)

could return what you want

Re: Contracted Table

Anonymous — Thu, 14 May 2015 15:00:33 GMT

It doesn't work.

Re: Contracted Table

Clever_Anjos — Thu, 14 May 2015 15:13:49 GMT

Would you mind sharing your app?

Re: Contracted Table

Anonymous — Thu, 14 May 2015 16:17:49 GMT

I Can't, but my original table is:

Depósito	Dia	Saldo Físico
ESTOQUE FILIAL ARAUCARIA	1	846.660,0
ESTOQUE FILIAL ARAUCARIA	2	1.770.338,0
ESTOQUE FILIAL ARAUCARIA	3	1.747.598,0
ESTOQUE FILIAL ARAUCARIA	4	1.747.598,0
ESTOQUE FILIAL ARAUCARIA	5	1.710.088,0
ESTOQUE FILIAL ARAUCARIA	6	1.740.136,0

When I contract the table I want to see only the last Saldo Físico (1.740.136,0).

Depósito	Saldo Físico
ESTOQUE FILIAL ARAUCARIA	1.740.136,0

And then when I expand again will appear the original table.

Can you help me??

Re: Contracted Table

Anonymous — Thu, 14 May 2015 16:18:36 GMT

Dimensions = Depósito, Dia

Expression = sum(Saldo Físico)

Re: Contracted Table

Clever_Anjos — Thu, 14 May 2015 16:24:50 GMT

FIRSTSORTEDVALUE(

AGGR(

sum(Saldo Físico),

Depósito, Dia

-(Dia)

)

retorna o que?

Re: Contracted Table

Anonymous — Thu, 14 May 2015 16:33:10 GMT

Expandido retorna:

Depósito	Dia	Saldo Físico
ESTOQUE FILIAL ARAUCARIA	1	5.844.106,0
ESTOQUE FILIAL ARAUCARIA	2	10.957.426,0
ESTOQUE FILIAL ARAUCARIA	3	10.132.676,0
ESTOQUE FILIAL ARAUCARIA	4	10.132.676,0
ESTOQUE FILIAL ARAUCARIA	5	9.861.746,0
ESTOQUE FILIAL ARAUCARIA	6	10.081.976,0

Contraído:

Depósito	Saldo Físico
ESTOQUE FILIAL ARAUCARIA	10.081.976,0

Quando está contraído está trazendo o valor correto, ultima linha, porém está calculando errado o valor quando está expandido.

Re: Contracted Table

Clever_Anjos — Thu, 14 May 2015 17:36:08 GMT

Teria como postar uma amostra da aplicação? Ou então enviar para clever@clever.com.br

Re: Contracted Table

Anonymous — Thu, 14 May 2015 18:33:57 GMT

Enviado por email

Re: Contracted Table

maxgro — Thu, 14 May 2015 19:07:59 GMT

load * inline [

Month , Day, Value

1 , 1, 12

1 , 2 , 23

1 , 3 , 15

1 , 4 , 20

1 , 5 , 30

2 , 2 , 23

2 , 4 , 20

2 , 3 , 15

];

if(Dimensionality()=2,sum(Value), subfield(concat(Value, '@', -Day),'@',1))

Re: Contracted Table

Clever_Anjos — Thu, 14 May 2015 19:27:33 GMT

Veja se atende

=if(Dimensionality()=4,sum(SALDOFISFINAL),sum({<DIA={"$(=MAX(DIA))"}>}SALDOFISFINAL))

Re: Contracted Table

Anonymous — Mon, 18 May 2015 12:06:12 GMT

Funcionou, muito obrigado.