Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join Problem

Hi everyone, i need some help with this:

I have an Inline table with these fields:

Div,Account, Sub-Account, Year, Month, Variable.

And another QVD with these fields:

Div,Account, Sub-Account, Year, Month, Sales

I need to do a join or something else, i need to multiply the sales to variable on the script and put the results in other table.

Does anyone can help me with this issue???

Regards

Orlando

1 Reply
Not applicable
Author

Hi Orlando,

You can left join the QVD to the first inline table so that you will get the variable and sales in same row and then you can multiple in the next resident load table.

regards

rajesh