Discussion Board for collaboration on QlikView Scripting.
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.
See my project attached.
Go to Solution.
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.
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.
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...
I entirely Modified the data Model and Please find the attached qvw.
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.
If you want Zero value if INCOME Missing, Goto to Presentation Tab and select 0 for Null Symbol & Missing Symbol.
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: