topic Re: How to do it at UI in QlikView

How to do it at UI

kunkumnaveen — Fri, 31 Aug 2018 09:12:28 GMT

Hi,

I have a raw data like this:

Regional	Area
A	AA
	AB
	AC
B	BA
	BB

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

So the record will be like this:

Regional	Area
A	AA
A	AB
A	AC
B	BA
B	BB

i want to do this at front end (UI)

Thanks in advance.

Re: How to do it at UI

sumeet-vaidya — Fri, 31 Aug 2018 09:26:27 GMT

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

Re: How to do it at UI

kunkumnaveen — Fri, 31 Aug 2018 09:29:44 GMT

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

Re: How to do it at UI

kunkumnaveen — Fri, 31 Aug 2018 09:31:52 GMT

By the data source is not Excel

Re: How to do it at UI

kunkumnaveen — Fri, 31 Aug 2018 09:39:58 GMT

Cant we can do it at front end?

Re: How to do it at UI

PrashantSangle — Fri, 31 Aug 2018 09:45:22 GMT

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

Re: How to do it at UI

sumeet-vaidya — Fri, 31 Aug 2018 11:44:45 GMT

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