Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

multiplying between 2 different tables

Hi im pretty sure this is the bread an butter of qlikview so unsure why it wont work,

in one table I have 2 field named contact name and hours worked

in another I have a contact name and rate.

the contact name is obviously the key but I cant seem to be ablr to multiply a persons hours worked with their associated rate.

the formula I have atm is =sum(hours) * rate

1 Solution

Accepted Solutions
MayilVahanan

HI

Combine both table by using left join, and then you can create new field by multiply hours and rate in script, then use that in expression.(dashboard)

Hope it helps

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
samuel_brierley
Creator
Creator
Author

an addition to the above is that I have a collum in the first table with labelled as date, the problem seem to be cause by this as the foirmula works ina text box but when I graph it with date as the dimension it wont work

MayilVahanan

HI

Combine both table by using left join, and then you can create new field by multiply hours and rate in script, then use that in expression.(dashboard)

Hope it helps

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.