Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Search instead for
Did you mean:
Contributor III

## Merge two fields from one table then append it with other tables

Hi Experts,

Please find attached qvw for clarity.

From Tab Induslnd I want to merge Emi_Amount and overdue_amount and then concate with other data .

I tried using concatenation but I get 2 rows for single amount.
I also tried in calculated dimension I wrote Amount+Emi_Amount+Overdue_amount , but it dint solve.

Please find below attached qvw for reference.

Please help.

Labels (1)
• ### tresesco

1 Solution

Accepted Solutions

see the attached

8 Replies

Instead in Dimension, Can you write below formula in expression

=sum(Amount)+sum(Ovedue_Amount)

Contributor III
Author

Thanks for quick response,

It dint solve, I Cant write it in calculated dimension, its giving me error. I have other expression to calculate.

@karunaramteke  What I meant is to write this in expression not in calculated dimension

see the attached

Contributor III
Author

@Kushal_Chawda Thank you so much1!!!

This also solved and below exp also
aggr(sum(Amount)+sum([Overdue Amount]),Payment_Mode,Transaction_Date,%Lan_ID,PORTAL)

Contributor III
Author

Can I create one single column in back end, Because I need to show all amount in data dump  like 100, 220, 300 in every row

I would not recommend to use below as simple measure solves the problem

aggr(sum(Amount)+sum([Overdue Amount]),Payment_Mode,Transaction_Date,%Lan_ID,PORTAL)

Yes. For one of the table you can do something like below

LOAD *,

rangesum([EMI Due Amount] ,[Overdue Amount]) as Final_Amount

FROM Table;

Then in expression you can use simply  Sum(Final_Amount)

Community Browser