Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Author

Gysbert,

It work's perfectly!

thank you very much!!