topic Re: How to Merge Multiple Row into One Row for Calculation in QlikView

How to Merge Multiple Row into One Row for Calculation

brijeshvma — Thu, 14 Jan 2016 17:49:11 GMT

I want to merge multiple row into one Row.. I Have Column

So i want whenever Barcode having multiple Process it Show it same row .. Because SID CID CLAID, FID, PLID, Having a Numeric Fix Value...

So i can compare say in Barcode AB1-0006 in Process (5 Prediction ) Confirm E CID but when Self check Done it show D CID ..

so it mean CID Variance 1 in Prediction 5 and Self ..... same way i can Compare any Process to any Process . and i can have Variance

Differece Column as well..

Kindly Check my Attach Data and Master table ...

sinanozdemir — Thu, 14 Jan 2016 20:05:50 GMT

Hi,

What is the expected output? Can you provide a sample output table?

Thanks

brijeshvma — Fri, 15 Jan 2016 05:28:33 GMT

Hi,

I want the Same Barcode Figure should be same Line .. so i can do Minus is that value ..

jagan — Fri, 15 Jan 2016 05:55:30 GMT

HI,

What is your expected output? can you attach your expected results.

Regards,

jagan.

zain16nib — Fri, 15 Jan 2016 06:38:11 GMT

Dear,

generic LOAD CAN HELP TO GET YOUR RESULT,

see example in attachment.

Regards,

Zain.

sinanozdemir — Fri, 15 Jan 2016 13:53:43 GMT

Can you please post a sample output? It is difficult to visualize what you are trying to accomplish.

Thanks