topic Filling in the missing Cells in App Development

Filling in the missing Cells

sapna — Sat, 23 Feb 2019 20:15:43 GMT

Hello,

I have a data set provided as below

Person	Location	Month	Sales
Bob	London	Jan	100
	New York	Feb	200
	London	Mar	300
Kate	New York	Jan	400
	London	Feb	500
	London	Mar	600
John	New York	Jan	100
Mark	London	Feb	200

All i need to do is fill the person name in the blank column in qlik.

Kindly suggest a way.

Re: Filling in the missing Cells

pradosh_thakur — Sun, 24 Feb 2019 06:57:50 GMT

load If(len(trim(Person))=0,peek(Person),Person) as Person , Location,	Month	,Sales Inline [
Person	,Location,	Month	,Sales
Bob	,London	,Jan	,100
	,New York	,Feb,	200
	,London,	Mar,	300
Kate,	New York,	Jan,	400
	,London	,Feb	,500
	,London	,Mar,	600
John	,New York	,Jan,	100
Mark,	London,	Feb	,200
];