Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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
HirisH_V7
Master
Master

Okay.

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

11 Replies
sunny_talwar

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

Chanty4u
MVP
MVP
Author

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

HirisH_V7
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!”
Chanty4u
MVP
MVP
Author

yes hirish.  other row   i need.

HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
HirisH_V7
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!”
Chanty4u
MVP
MVP
Author

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

pay.PNG

can you share your Sample Qvw.

HirisH_V7
Master
Master

Okay.

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Chanty4u
MVP
MVP
Author

Thank you hirish