topic Re: Loading combine rows in Qlik in QlikView

Loading combine rows in Qlik

Tue, 24 Nov 2015 10:28:32 GMT

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

Re: Loading combine rows in Qlik

Tue, 24 Nov 2015 11:15:47 GMT

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

Re: Loading combine rows in Qlik

sunny_talwar — Tue, 24 Nov 2015 11:17:15 GMT

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.

Re: Loading combine rows in Qlik

Anonymous — Tue, 24 Nov 2015 11:20:46 GMT

try this at script level like:

concat(Field1, Field2) as ConcatenatedFieldName

Hope this help!!

Re: Loading combine rows in Qlik

Tue, 24 Nov 2015 11:22:21 GMT

Thanks for all!! It works!!

Re: Loading combine rows in Qlik

Tue, 24 Nov 2015 14:55:52 GMT

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?

Re: Loading combine rows in Qlik

sunny_talwar — Tue, 24 Nov 2015 16:00:52 GMT

Would you be able to share a small sample?