Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER NOW
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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!!