no relation dimension and detail

[Anonymous]

I have a dimension table .it has just 3 rows and single column like 2012,2011,Last 12 Months(for current year,for previous year, for last 12 mm now last12mm meanings 2012sep to 2012oct).

i have detail table which contains columns like cy_jan,cy_feb....cy_sep,cy_total(cy all total)

                                                                    ly_jan-ly_dec,ly_total(ly all total)   etc........

i want to know

if anybody click on 2012 it will display cy_jan---to -cy_sep

                                      click on 2011 it will display ly_jan-------to--ly_dec

                                      click on Last 12 Months it will display cy_sep-------to--ly_oct

is it possible in qlikview?

[#2]

You must have common key fields in both table. You can add the year on the second table.

Best Regards.

[Anonymous]

Hi Anutosh can you put that data in the excel sheet so that it will be easy for understanding.

[Anonymous]

Hi Vinay,

i am sending .xls file sorry for the delay as i was in hospital.

CONTINENT_ID	COUNTRY_ID	CONTINENT	COUNTRY	SEG	SEG_ID	SPU	SPU_ID	BU	BU_ID	PU	PU_ID	SUBPU	SUBPU_ID	MKT_SEC	MKT_SEC_ID	MKT_SUB_SEC	MKT_SUB_SEC_ID	COMM_GROUP	COMM_GROUP_ID	COMM	COMM_ID	SUB_COMM	SUB_COMM_ID	ACCOUNTABILITY_GROUP_ID	SUPPLIER_ID	SUPPLIER	MASTER_SUPPLIER_ID	MASTER_SUPPLIER	CY_JAN	CY_FEB	CY_MAR	CY_APR	CY_MAY	CY_JUN	CY_JUL	CY_AUG	CY_SEP	CY_OCT	CY_NOV	CY_DEC	CY_TOTAL	LY_JAN	LY_FEB	LY_MAR	LY_APR	LY_MAY	LY_JUN	LY_JUL	LY_AUG	LY_SEP	LY_OCT	LY_NOV	LY_DEC	LY_TOTAL	C2Y_JAN	C2Y_FEB	C2Y_MAR	C2Y_APR	C2Y_MAY	C2Y_JUN	C2Y_JUL	C2Y_AUG	C2Y_SEP	C2Y_OCT	C2Y_NOV	C2Y_DEC	C2Y_TOTAL	L12M_TOTAL	LYTD_TOTAL	YTM_C2Y_TOTAL	ACCOUNTABILITY_GROUP_NAME	LY_L12M_TOTAL
1418422	1418279	Asia	India	Alternative	1985430	Solar	1985471	Asia Pacific	1985505	Solar	1985507			Alternative	1909120	Solar Projects	1920907	Construction	1939579					4	2163947	A	2163947	A	0	0	0	9,722	3,121	0	1,453	0	0	0	0	0	14,296	0	0	0	0	0	10,421	11,301	15,901	0	18,536	27,447	0	83,607	0	0	0	0	0	0	0	0	0	0	0	0	0	76,181	21,722	0	Alternative	21,722
1418422	1418279	Asia	India	Alternative	1985430	Solar	1985471	Asia Pacific	1985505	Solar	1985507			Alternative	1909120	Solar Projects	1920907	Construction	1939579					4	2170567	B	2170567	B	60,121	0	20,608	0	2,480	22,833	14,102	0	0	0	0	0	120,144	0	0	0	0	0	0	39,786	221,375	0	77,907	83,271	0	422,338	0	0	0	0	0	0	0	0	0	0	0	0	0	502,696	39,786	0	Alternative	39,786
1418422	1418279	Asia	India	Alternative	1985430	Solar	1985471	Asia Pacific	1985505	Solar	1985507			Alternative	1909120	Solar Projects	1920907	Construction	1939579					4	2170597	C	2170597	C	0	0	12,311	0	0	0	0	0	0	0	0	0	12,311	0	0	0	0	0	0	15,420	29,270	27,864	0	30,373	0	102,927	0	0	0	0	0	0	0	0	0	0	0	0	0	99,818	15,420	0	Alternative	15,420
1418422	1418279	Asia	India	Alternative	1985430	Solar	1985471	Asia Pacific	1985505	Solar	1985507			Alternative	1909120	Wind Projects	1920907	Construction	1939579					4	2170659	D	2170659	D	42,242	46,256	105,452	48,198	16,570	0	24,074	0	0	0	0	0	282,792	0	0	0	0	0	0	69,793	124,469	0	70,666	34,224	83,448	382,599	0	0	0	0	0	0	0	0	0	0	0	0	0	595,599	69,793	0	Alternative	69,793

[Anonymous]

please help me.....

[Anonymous]

Hi Anutosh,

the data which you have attached is ok but i am unable to copy and paste into any of the excel sheets. Can you attach the excel sheet directly. for attaching any document use advanced editor.

[Anonymous]

please find the attached files which contains sample data

[Anonymous]

Hi vinay have you gone through my xls?