Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Repeat First Row

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

Expression:

Capturar.JPG

4 Replies
hrlinder
Honored Contributor

Re: Repeat First Row

if you have identifier for first row (e.g. rowno) you can try

if (rowno()=2, previous(yourfieldinfirstrow), elsefield) as columnfield

Re: Repeat First Row

It can be done using a TOTAL qualifier, but since you don't need the final grand total, you would need to specify the field name you are totaling it on.

Sum(TOTAL <FieldName> Sales)

FieldName would be the same one as the field with Partial Sum

I hope this helps.

Best,

Sunny

Not applicable

Re: Repeat First Row

Hi Sunny,

If I use TOTAL, the result is the sum of all my selection... not just the column.

image below...

Capturar1.JPG

Not applicable

Re: Repeat First Row

Here my QVW....

Community Browser