Discussion Board for collaboration on QlikView Scripting.
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...
if you have identifier for first row (e.g. rowno) you can try
if (rowno()=2, previous(yourfieldinfirstrow), elsefield) as columnfield
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.
If I use TOTAL, the result is the sum of all my selection... not just the column.
Here my QVW....