topic Re: Repeat First Row in QlikView

Repeat First Row

Wed, 05 Aug 2015 21:18:59 GMT

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:

Re: Repeat First Row

Anonymous — Wed, 05 Aug 2015 21:29:17 GMT

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

sunny_talwar — Wed, 05 Aug 2015 23:01:44 GMT

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

Re: Repeat First Row

Thu, 06 Aug 2015 11:20:42 GMT

Hi Sunny,

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

image below...

Re: Repeat First Row

Thu, 06 Aug 2015 11:36:52 GMT

Here my QVW....