Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
qluser01
Not applicable

Autofill blank (grouped) Excel values from previous row on load in Sense

Hi!

I need to load an Excel file into SENSE

Table has grouped rows (see example)

In QlikView I can use Fill Cells option.

How to do it in Sense????

See attached XSLX file for example, try to load it...

1 Solution

Accepted Solutions
qluser01
Not applicable

Re: Autofill blank (grouped) Excel values from previous row on load in Sense

I did it using Previous() command like:

load

if ( len(col1)<=0, Previous(col1), col1) as col1

...

1 Reply
qluser01
Not applicable

Re: Autofill blank (grouped) Excel values from previous row on load in Sense

I did it using Previous() command like:

load

if ( len(col1)<=0, Previous(col1), col1) as col1

...