Year/Month filter for different tabs

[#1]

Hello -

I have two sets of data at different levels of details. Both tables are loaded from excel spreadsheet and have year and month in the spreadsheets. When I pulled one table in to Qlikview and created a filter for year and month followed by second tab with other set of data, my totals were combined on 1st tab. I was wondering if there is a way to use year/month filters for both tabs but still show correct totals. Would date island be the way to go? I am having difficulty using date islands.

Any suggestions would be helpful.

Thanks!

[spividori]

Hi.

You should create a month-year field in each table for the establishment of a link between the two tables and use this field to filter..

If not you could upload an example to understand?.

Regards.

[#3]

I tried doing that but on the main dashboard, my totals were combined from both tabs and they shouldn't be because the data is different. That is the reason why I was thinking of using date island.

Thanks

[spividori]

Sorry, I do not understand, you have some sample data to publish and to help.

Regards.

[#5]

I don't have a sample data as it is not working but i will try to explain.

Tab 1 shows the follwoing:

Company	Year	Month	Sales
DEL	2013	Aug	10,000
CLV	2013	Aug	23,000
KPS	2013	Sep	4,365
			37,365

Tab 2

Company	Vendor	Year	Month	Variances
DEL	A++	2013	Aug	2,300
CLV	3M	2013	Aug	4,500
KPS	Fila	2013	Sep	1,200
				8,000

on the top of the tab, I put filter for year and month and 1st tab should only pick up totals from Tab 1 but now it adds up Variances from tab 2 as well. So I need that year filter to drive both tabs but totals should remain 37,365 for tab 1 and 8000 for tab 2 not sum of both.

Hope this makes sense. I don't have example because I cannot make it work at the moment.

Thanks

[#6]

load the data in the following manner:

tab1:

load company as company1,year,month,sales from <sheet1>;

tab2:

load company as company2,vendor,year,month,variances from <sheet2>;

then under first tab, select company1 as dimension,

and company2 in second tab

[Gysbert_Wassenaar]

Not sure what you're trying to do. Perhaps this discussion can help you: Tutorial - Using Common Date Dimensions and Shared Calendars

[#8]

Yes I have done that but now I want to use year and month as a filter at the top of the tab that would filter both tabs.

When I added Period or Year and Month at the top and clicked on 2013, the totals from 1st tab and 2nd tab were summed together. But frist tab should only show sum for sheet 1 and when I click on SUpplier tab, sum for 2013 shoudl show only sum for sheet 2.

Thanks

[#9]

Can You tell me the dimensions and expressions you have used on both tabs?

[#10]

I used YR_NBR on both tabs and MTH_STR on both tabs. For expression I used Sum(Amt This Period) on 1st tab and Sum(Amount This Period) on 2nd tab. The amount column names are different between two tabs but the 1st tab still adds 2nd tabs totals.

Thanks