Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Filling in the missing Cells

Hello,

I have a data set provided as below

PersonLocationMonthSales
BobLondonJan100
 New YorkFeb200
 LondonMar300
KateNew YorkJan400
 LondonFeb500
 LondonMar600
JohnNew YorkJan100
MarkLondonFeb200

 

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

Kindly suggest a way.

1 Solution

Accepted Solutions
Master II
Master II

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
];
Learning never stops.

View solution in original post

1 Reply
Master II
Master II

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
];
Learning never stops.

View solution in original post