Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to combine 2 table into 1 ?

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

12 Replies
paulyeo11
Master
Master
Author

my qvw

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

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

Sample.JPG

paulyeo11
Master
Master
Author

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>

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

‌Hi Anil

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

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

‌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

Anil_Babu_Samineni

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 ..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

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