Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Champion III
Champion III

RE:Seperate column

Hi all ,

Sunny T

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

1 Solution

Accepted Solutions
Master
Master

Okay.

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

11 Replies

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

Champion III
Champion III

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

Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
Champion III
Champion III

yes hirish.  other row   i need.

Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
Master
Master

Hi Suresh,

Morning!

is this what your'e looking for,

Grouping of Dimension-237604.PNG

Else, Let me know your requirement with further details.

-hirish

HirisH
“Aspire to Inspire before we Expire!”
Champion III
Champion III

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

pay.PNG

can you share your Sample Qvw.

Master
Master

Okay.

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

Champion III
Champion III

Thank you hirish