Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

How to do it at UI

Hi,

I have a raw data like this:

RegionalArea

A

AA
AB
AC
BBA
BB

I want to fill blank regional column with the value above.

So the record will be like this:

RegionalArea

A

AA
AAB
AAC
BBA
BBB

i want to do this at front end (UI)

Thanks in advance.

1 Solution

Accepted Solutions
PrashantSangle

Yes we can do it front end as well as in back end

Front End

Dimension: Area

Expression  : If(len(Trim(Regional))=0,Above(Regional1),Regional)                // Give Expression Name as Regional1

Back End

Use peek() try below

if(len(Trim(Regional))=0,Peek(Regional),Regional) as Regional

Then use Use Regional field in front end.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

6 Replies
sumeet-vaidya
Partner - Creator
Partner - Creator

Hi Naveen,

While loading data from excel, please follow below steps to Fill blank records with previous values.

Enable Transformation Steps -> Fill -> Fill button -> Cell Condition (is empty) -> Next - Finish

Eg:-

LOAD

     Region,

     Area

FROM

test_123.xls

(biff, embedded labels, table is Sheet1$, filters(

Replace(1, top, StrCnd(null))

));

Regards

Sumeet

kunkumnaveen
Specialist
Specialist
Author

cant write any set analysis? i want to do it at front end

kunkumnaveen
Specialist
Specialist
Author

By the data source is not Excel

kunkumnaveen
Specialist
Specialist
Author

Cant we can do it  at front end?

PrashantSangle

Yes we can do it front end as well as in back end

Front End

Dimension: Area

Expression  : If(len(Trim(Regional))=0,Above(Regional1),Regional)                // Give Expression Name as Regional1

Back End

Use peek() try below

if(len(Trim(Regional))=0,Peek(Regional),Regional) as Regional

Then use Use Regional field in front end.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
sumeet-vaidya
Partner - Creator
Partner - Creator

Hi,

Yes, Use Above function as stated below,

If(Isnull(Region) OR len(Trim(Region))=0, Above(Region_New),Region) ==> Name this expression as Region_New

Regards

Sumeet