Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tomcatxx
New Contributor II

How to repeat first value into next rows?

Hi there. A simple question.

C1
26082018

How Can I repeat that value into next row?  Use peek() pls.

Thank you.

2 Replies
Quy_Nguyen
Contributor III

Re: How to repeat first value into next rows?

Hope this help

A:

LOAD * INLINE

[

C1

26082018,

27082018

28082018

];


B:

Load C1, Peek(C1) as LastValue

Resident A;

Drop Table A;

Re: How to repeat first value into next rows?

There is only one row in the sample data you provided... what exactly the output needs to look like for the above example?

Community Browser