topic Re: Merging Data Together doesn't work in QlikView

Merging Data Together doesn't work

Sun, 27 Jul 2014 15:37:38 GMT

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.

Re: Merging Data Together doesn't work

Sun, 27 Jul 2014 22:10:47 GMT

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.

Re: Merging Data Together doesn't work

Sun, 27 Jul 2014 22:23:04 GMT

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.

Re: Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 02:43:01 GMT

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

Re: Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 05:25:24 GMT

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.

Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 15:27:29 GMT

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

Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 17:11:16 GMT

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:

Re: Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 17:13:49 GMT

The file..

Re: Re: Merging Data Together doesn't work

Mon, 28 Jul 2014 17:18:55 GMT

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

Please find the attached qvw as reference.

I am not sure where did u add the data.