İmport excel format merge measure

[krmvacar]

Hi all ,

I have the data I got from excel. They want to see it in the same format as below on Qlik Sense.

Is it possible to show it in this format?

When I import it into Qliksense, it assigns the value to the first row and shows the other values as zero.

ID	Country	City	Salary
23452	TURKEY	İzmit	10.000,00
23452	TURKEY	İzmit
23452	TURKEY	Osmangazi
23452	TURKEY	Merkez
23452	TURKEY	Gölcük

[Or]

You will not be able to replicate this exact format with Qlik's native objects, as far as I know. If you use a pivot and use Salary as the first dimension (or second, or third), you will get a merged cell for that, but it has to be left of the city or it'll get broken down into rows.

[vinieme12]

use the peek() function to fill-down the values from the previous row

As below

LOAD

ID

,Country

,City

,If(Len(Salary),Salary,Peek(Salary_2)) as Salary_2

From Xyz.xlsx;