Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

add two fields from different tables

hi

i need to add two fields from different tables. and check with condition like values > 0  and display it in chart for current month

any suggestions ?

14 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

May be it will help if you elaborate little more to the community.

arulsettu
Master III
Master III
Author

hi

for example field1 from table1

and field two from table2

i need to add these two fields and check these fields value > 0

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

so some thing like below ?

=if(Sum(Field1)+sum(Field2) > 0, 'TRUE','FALSE')

arulsettu
Master III
Master III
Author

any help?

anbu1984
Master III
Master III

What is the join key?

arulsettu
Master III
Master III
Author

condition like

orderquantity - shipped quantity

so it will check the values > 0

arulsettu
Master III
Master III
Author

item number is join key

arulsettu
Master III
Master III
Author

mapping load with apply map would be helpful for this scenario?

arulsettu
Master III
Master III
Author

can you suggest any idea?