topic Re: RE:Seperate column in QlikView

RE:Seperate column

Chanty4u — Tue, 25 Oct 2016 14:35:29 GMT

Hi all ,

I have data like Paid and Received . tables with the column names for the month of April ... and i have same paid and recvd for every month .

PaidTable:

Date ProductName PaidAmount

ReceivedTable:

Date Productname RecvdAmount

so now my requirement is:

1) in paid table having same product transaction is multiple times so i need to sum of the products amount in Paid and Received tables

2) and i need create the column PaidAmount-ReprievedAmount as summary

and if PaidAmount-RecievedAmount is Negative display as Payable

if it is positive display as receivable

Thanks in advance

Re: RE:Seperate column

sunny_talwar — Tue, 25 Oct 2016 15:51:56 GMT

What is the expected output in terms of numbers that you would want to see?

Re: RE:Seperate column

Chanty4u — Tue, 25 Oct 2016 16:19:52 GMT

Hi sunny,

all yellow and green [Means having multiple transactions with same productname] product amount should be summed and disply in seperate column as Total amount of each product for both the tables. hope this is clear.

be screen shots

Re: RE:Seperate column

HirisH_V7 — Tue, 25 Oct 2016 17:58:25 GMT

Hi Suresh,

You want to see above output or their you mentioned as 'disply in seperate column as Total amount of each product' Means another row or what!!

-Hirish

Re: RE:Seperate column

Chanty4u — Tue, 25 Oct 2016 17:59:33 GMT

yes hirish. other row i need.

Re: RE:Seperate column

HirisH_V7 — Tue, 25 Oct 2016 18:03:48 GMT

Can You Post in a excel sheet what your'e looking for.

Re: RE:Seperate column

HirisH_V7 — Wed, 26 Oct 2016 06:06:20 GMT

Hi Suresh,

Morning!

is this what your'e looking for,

Else, Let me know your requirement with further details.

-hirish

Re: RE:Seperate column

Chanty4u — Wed, 26 Oct 2016 06:52:28 GMT

yes hirish, We are done that but need to check with my Manager .

can you share your Sample Qvw.

Re: RE:Seperate column

HirisH_V7 — Wed, 26 Oct 2016 07:22:12 GMT

Okay.

PFA,

Hirish

Re: RE:Seperate column

Chanty4u — Wed, 26 Oct 2016 08:22:09 GMT

Thank you hirish

Re: RE:Seperate column

Chanty4u — Wed, 26 Oct 2016 17:31:43 GMT

Hi hirishv7,

this is exact requirment can you help on this?

we need to have one table combining both Paid& Recvd as summary. then need to have two different tables one for Recvd and one for Paid. The summary table will have product wise “Receivable” column and “Payable” column. If Recvd amount is greater than Payable amount then the value will be in “Receivable” column else in “Payables” column.

Thanks

chanty

Re: RE:Seperate column

HirisH_V7 — Wed, 26 Oct 2016 18:20:01 GMT

Hi Suresh ,

I can understand your'e Requirement half away, To make it clear can You make it on Excel or In form of any Columns and Grouping done between them.

-Hirish