Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Repeat First Row

**Repost with QVW.

Hi!

Does anybody knows how to repeat the valeu of the first row from the first column over all the rows in the second column like the image bellow?

I could only repeat the first line...

Capturar.JPG

Tags (1)
1 Solution

Accepted Solutions

Re: Repeat First Row

Try

SUM(TOTAL <DS_RUBRICA,[Período DRE]> AGGR(NODISTINCT sum({<DS_RUBRICA = {'(=) TOTAL DA RECEITA'}, NR_SEQ_MODELO = {41}>}DRE_VALOR_RUBRICA),[Período DRE]))


talk is cheap, supply exceeds demand
2 Replies

Re: Repeat First Row

Try

SUM(TOTAL <DS_RUBRICA,[Período DRE]> AGGR(NODISTINCT sum({<DS_RUBRICA = {'(=) TOTAL DA RECEITA'}, NR_SEQ_MODELO = {41}>}DRE_VALOR_RUBRICA),[Período DRE]))


talk is cheap, supply exceeds demand
Not applicable

Re: Repeat First Row

Gysbert,

It work's perfectly!

thank you very much!!

Community Browser