topic Re: Merge two fields from one table then append it with other tables in QlikView

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

karunaramteke — Sat, 16 Nov 2024 18:16:33 GMT

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.

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

Kushal_Chawda — Mon, 03 Aug 2020 11:29:27 GMT

Instead in Dimension, Can you write below formula in expression

=sum(Amount)+sum(Ovedue_Amount)

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

karunaramteke — Mon, 03 Aug 2020 11:38:09 GMT

Thanks for quick response,

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

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

Kushal_Chawda — Mon, 03 Aug 2020 11:48:42 GMT

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

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

Kushal_Chawda — Mon, 03 Aug 2020 11:52:39 GMT

see the attached

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

karunaramteke — Mon, 03 Aug 2020 12:38:57 GMT

@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)

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

karunaramteke — Mon, 03 Aug 2020 12:57:25 GMT

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

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

Kushal_Chawda — Mon, 03 Aug 2020 12:58:49 GMT

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)

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

Kushal_Chawda — Mon, 03 Aug 2020 13:11:56 GMT

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)