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: 
Not applicable

Merging Data Together doesn't work

Hi.

I have two tables, one master - Incomes showing my incomes by id's (my sales by item),

and i want to be able to tell each Id it's expense.

Expenses are loaded from another table.

When I bring it all together,
Each Id has it's expense. great.

But, when i want to present in a pivot, all incomes and expenses,

Expesnes which has no Incomes in the other side but i can't.

Help...

See my project attached.

1 Solution

Accepted Solutions
Not applicable
Author

Hi Gil, I added the new row to Expense Table in my qvw then I can able to see the data like below:

Comm127781.JPG.jpg

Please find the attached qvw as reference.

I am not sure where did u add the data.

View solution in original post

8 Replies
Not applicable
Author

Hi Gil, You have Synn Keys on your data model.

As per my understanding on your requirement, I modified the data model.

Please find the attached app.

Not applicable
Author

Hi.

Still as you can see, the sum of expenses in the original table sums to: 36,000

and in the pivot table it sums to: 33,000.

I would appriaciate if you can continue solving it out for me...

thank you.

Not applicable
Author

I entirely Modified the data Model and Please find the attached qvw.

Not applicable
Author

Hi dathu.

It took me time to learn your solution. It is great.

I have one last question.

When I add an expense to a car, that had no income at all,

for example add item 2014, 01, 300, 1000 (year,month,car,expense) to expenses.

It's missing in the pivot.

what do i do, for it to show?

Thank You, Gil.

Not applicable
Author

If you want Zero value if INCOME Missing, Goto to Presentation Tab and select 0 for Null Symbol & Missing Symbol.

Not applicable
Author

I Wasn't pointing there. I attached file.

As i said i added an item: 2014, 01, 300, 1000 (year,month,car,expense) to expenses

I want the pivot the present car 300, automatically with the new expense.

If I click populate missing values i get this:

Untitled.png

Not applicable
Author

The file..

Not applicable
Author

Hi Gil, I added the new row to Expense Table in my qvw then I can able to see the data like below:

Comm127781.JPG.jpg

Please find the attached qvw as reference.

I am not sure where did u add the data.