topic Re: Year/Month filter for different tabs in QlikView

Year/Month filter for different tabs

Fri, 08 Nov 2013 20:11:46 GMT

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!

Re: Year/Month filter for different tabs

spividori — Fri, 08 Nov 2013 20:46:39 GMT

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.

Re: Year/Month filter for different tabs

Fri, 08 Nov 2013 21:11:16 GMT

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

Re: Year/Month filter for different tabs

spividori — Fri, 08 Nov 2013 21:24:34 GMT

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

Regards.

Re: Year/Month filter for different tabs

Fri, 08 Nov 2013 21:36:48 GMT

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

Re: Year/Month filter for different tabs

Sat, 09 Nov 2013 06:23:05 GMT

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

Re: Year/Month filter for different tabs

Gysbert_Wassenaar — Sat, 09 Nov 2013 10:00:31 GMT

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

Re: Year/Month filter for different tabs

Sat, 09 Nov 2013 11:28:26 GMT

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

Re: Year/Month filter for different tabs

Mon, 11 Nov 2013 09:23:59 GMT

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

Re: Year/Month filter for different tabs

Mon, 11 Nov 2013 15:28:49 GMT

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