topic Re: How to combine 2 table into 1 ? in QlikView

How to combine 2 table into 1 ?

paulyeo11 — Fri, 15 Dec 2017 01:20:47 GMT

Hi All

I have 2 Table :-

Table 1 Expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1))

Table 2 Expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1))

May i know how to combine both table into 1 Table. and user just need to click on the button >90 Day or > 120 day ?

Now i manage this issue by 2 sheet.

Paul Yeo

Re: How to combine 2 table into 1 ?

paulyeo11 — Fri, 15 Dec 2017 01:21:55 GMT

my qvw

My Table 2 Expression , instead of 91 , it should be 121.

Re: How to combine 2 table into 1 ?

krishnacbe — Fri, 15 Dec 2017 17:12:13 GMT

Create a variable and assign 91/ 121 based on button click and assign that variable in Expression.

The Expression in your Table should be as below

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDays)'} >}total_ar * 1) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDays)'} >}total_ar * 1))

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 02:57:05 GMT

Hi Sir

Thank you very much , this will be my week end assignment.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: How to combine 2 table into 1 ?

Anil_Babu_Samineni — Sat, 16 Dec 2017 04:05:08 GMT

PFA

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 04:48:01 GMT

‌Hi Anil

thank you very much , can’t wait to open the file attachment

Re: How to combine 2 table into 1 ?

Anil_Babu_Samineni — Sat, 16 Dec 2017 04:59:31 GMT

PFA

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 05:09:24 GMT

‌Hi Anil

May I know why you have the patience to come out the alternative solution ?

I think there must be benefit you gain ?

Paul

Re: How to combine 2 table into 1 ?

Anil_Babu_Samineni — Sat, 16 Dec 2017 05:51:33 GMT

May I know why you have the patience to come out the alternative solution ?

We can not say Patience, But i have time due to week end. So, I am trying with all possible inputs

I think there must be benefit you gain ?

What do you mean that? Do you think we are offering for Benefits, No way. We are just helpers. Anyway, Does this answer to your thread? If so, Please mark it as Help and Flag Correct answer If not, Please free to ask ..

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 06:47:33 GMT

Hi Anil

Thank you for your sharing. Your approach is very simple , but some time can be confusing.

I expect you to said the benefit on offer multiple solution , you will learn a lot more then other , and you will become very detail and clear about what the expression behaviors.

Now i am going to try the solution offer by another user. which create variable.

Paul Yeo

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 06:49:31 GMT

Hi Krish

Many thank for your sharing.

I have try but it does not work.

Hope you can point to me where i go wrong ?

Paul Yeo

Re: How to combine 2 table into 1 ?

paulyeo11 — Sat, 16 Dec 2017 10:17:20 GMT

Hi Krish

Hi Sir

I manage to figure out , and now it is working fine in table 1.

I now need to modify the expression to compute >90 day and less then 120 day.

I expect the result of the table should display 5304 and 687.

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1')} >}total_ar * 1) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1)'} >}total_ar * 1))

I have try the above expression , but it does not return any value.

Paul

Re: How to combine 2 table into 1 ?

paulyeo11 — Fri, 22 Dec 2017 02:43:57 GMT

Hi Krish

I post one more similar issue , can you help to take a look ?

Create var vYn1 and replace 8 with $(vYn1) not working ?

Paul