topic Logic Help in QlikView

Logic Help

abhaysingh — Wed, 24 Feb 2016 10:29:30 GMT

Hi Guys,

I need small help here,

i have on table in which fileds are let say GLCode, PFCentre both have values in it like 22222, 1001 etc and a amount

i want to append composite key of GLCode, PFCentre below the GLCode

for eg

GLCode

22222,

22222|1001

so now you can see it has two record in GLCode.. I want to do this in single table so that w.r.t . value 22222|1001 i can able to get amount as well, Possible?

thanks

Re: Logic Help

Chanty4u — Wed, 24 Feb 2016 10:35:47 GMT

LOAD *,

GLCode& '-' & '-' & PFCentre as GLcode,

Re: Logic Help

Anonymous — Wed, 24 Feb 2016 10:36:22 GMT

may be like this?

Load

GLCode

...

Concatenate

Load

GLCode&'|'&PFCenter as GLCode

Re: Logic Help

abhaysingh — Wed, 24 Feb 2016 10:37:02 GMT

in that case i can able to get the amount

Re: Logic Help

sunny_talwar — Wed, 24 Feb 2016 10:37:26 GMT

so you said they need to have amount? what amount would it show (the second row)? sum of 22222 and 1001 or just amount related to 1001?

Re: Logic Help

abhaysingh — Wed, 24 Feb 2016 10:37:55 GMT

Hi Suri i want to append the value of two different field into one, this is what i want

Re: Logic Help

puttemans — Wed, 24 Feb 2016 10:40:51 GMT

Hi there,

Can you get a small example of what you need? I suppose you have the key, and then a separate field with the amounts. what do you want the amounts to do? Duplicate? Sum?

Kind regards,

Johan

Re: Logic Help

Anonymous — Wed, 24 Feb 2016 10:41:03 GMT

What exactly you want to achieve?

Say amount is 100

GLCode, Amount
22222, 100

22222|1001, 100 or Blank??

Re: Logic Help

abhaysingh — Wed, 24 Feb 2016 10:46:35 GMT

GLCode, Amount
22222, 100

22222|1001, it may change, w.r.t 22222 GL code the value is 100 w.r.t different PFCentre, so out of so many profit centre 22222|1001 have some value let say 10, i want to pick 10

Re: Logic Help

Anonymous — Wed, 24 Feb 2016 10:48:40 GMT

sample Data?