Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qluser01
Creator
Creator

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
Creator
Creator
Author

I did it using Previous() command like:

load

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

...

View solution in original post

1 Reply
qluser01
Creator
Creator
Author

I did it using Previous() command like:

load

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

...