topic Re: is it possible to transform one column from loaded table to Row in QlikView

is it possible to transform one column from loaded table to Row

Fri, 17 Jul 2009 14:53:53 GMT

Dear All,

I am facing difficulty in loading KNOV table from SAP system

it is having conditions

So what i am facing is when i am joining KONV with VBRK VBRP it is creating multiple rows for each invoice but having multiple conditions in KONV .

So entries are getting repeated and my qty total value comes double then actual one.

So i thought that in KONV if only condition column can be converted into row i can stop multiple entries and my Column total will then match.

Can i use transpose option to convert condition column only from KONV to a single row.

Regards

Raj

Fri, 17 Jul 2009 17:23:44 GMT

Maybe you can use the Crosstable feature ?

amars — Fri, 17 Jul 2009 17:52:10 GMT

Hi Raj,

I am not sure, but see if the attached example help's

Regard's

Amar

Fri, 21 Jun 2013 10:44:41 GMT

Hi,

But what is correct solution for this.

Thanks

Ritul

Sat, 29 Jun 2013 06:20:15 GMT

Hi,

I have a same problem do you get any perfect solution for this. Then please let me know if you get any solution for this.

Thanks