Loading combine rows in Qlik

[#1]

Hello my friends!

I have a problem loading a merge/combine cells, I would like to add the name of the Merge/combine cells in all the fields but I don´t know how to do that

    

[#2]

Hi Juan,

have a look at using peek for this

if(SE_MMPP_CTR<>Peek(SE_MMPP_CTR), SE_MMPP_CTR, Peek(SE_MMPP_CTR) As SE_MMPP_CTR

or something along those lines

hope that helps

Joe

[sunny_talwar · Accepted solution]

You can use Peek/Previous functions to do this.

Something like this:

If(Len(Trim(NameofTheField)) = 0, Peek(NameofTheField), NameofTheField) as NameofTheField,

You just need to make sure that sorting is done correctly, else you will see weird results.

[Anonymous]

try this at script level like:

concat(Field1, Field2) as ConcatenatedFieldName

Hope this help!!

[#5]

Thanks for all!! It works!!

[#6]

Sorry but I check the Qlik and the layout was the following:

it seems like it add one more value for each aprt of the field but it didn´t fulfill all the GAPS. any idea?

[sunny_talwar]

Would you be able to share a small sample?