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: 
Anonymous
Not applicable

Volume semana anterior

Prezados, boa tarde.

Vejam, por gentileza, se podem me ajudar. Tenho uma tabela com quebra(colunas) por semana, e cada semana tem seu respectivo volume.

Preciso acrescentar uma linha (volume semana anterior) e cada coluna nesta linha deve exibir o volume da semana anterior.

Vejam a imagem abaixo

week.png

Na coluna 9 a nova linha deverá exibir valor de 448 que é o volume da semana 8, na coluna 8 o volume deve ser 139 que é o volume da semana 7 e por aí vai.

A formula que uso para volume é

sum({$<VTYPE={ 010 }>}_volume)

Obrigado.

1 Solution

Accepted Solutions
PrashantSangle

try below function as per your requirement.

above()

or below()

or after()

or before()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
el_aprendiz111
Specialist
Specialist

Hi,

1 option:

ABBELO.png

Anonymous
Not applicable
Author

Bom dia Fer Fer,

Obrigado, mas não deu certo.

Veja por favor a imagem. Será que tem alguma outra solução ?

week1.PNG

PrashantSangle

try below function as per your requirement.

above()

or below()

or after()

or before()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Perfect !

Before is the correct answer....

Tks !!