Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Re: Merging Data Together doesn't work

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.

8 Replies
Not applicable

Re: Merging Data Together doesn't work

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

Re: Merging Data Together doesn't work

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

Re: Re: Merging Data Together doesn't work

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

Not applicable

Re: Re: Merging Data Together doesn't work

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

Re: Merging Data Together doesn't work

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

Not applicable

Re: Merging Data Together doesn't work

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

Re: Re: Merging Data Together doesn't work

The file..

Not applicable

Re: Re: Merging Data Together doesn't work

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.

Community Browser