Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anutosh_dhar
Contributor

no relation dimension and detail

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?

7 Replies
Not applicable

Re: no relation dimension and detail

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

Best Regards.

vinay_bangari
Valued Contributor III

Re: no relation dimension and detail

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

anutosh_dhar
Contributor

Re: no relation dimension and detail

Hi Vinay,

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

CONTINENT_IDCOUNTRY_IDCONTINENTCOUNTRYSEGSEG_IDSPUSPU_IDBUBU_IDPUPU_IDSUBPUSUBPU_IDMKT_SECMKT_SEC_IDMKT_SUB_SECMKT_SUB_SEC_IDCOMM_GROUPCOMM_GROUP_IDCOMMCOMM_IDSUB_COMMSUB_COMM_IDACCOUNTABILITY_GROUP_IDSUPPLIER_IDSUPPLIERMASTER_SUPPLIER_IDMASTER_SUPPLIERCY_JANCY_FEBCY_MARCY_APRCY_MAYCY_JUNCY_JULCY_AUGCY_SEPCY_OCTCY_NOVCY_DECCY_TOTALLY_JANLY_FEBLY_MARLY_APRLY_MAYLY_JUNLY_JULLY_AUGLY_SEPLY_OCTLY_NOVLY_DECLY_TOTALC2Y_JANC2Y_FEBC2Y_MARC2Y_APRC2Y_MAYC2Y_JUNC2Y_JULC2Y_AUGC2Y_SEPC2Y_OCTC2Y_NOVC2Y_DECC2Y_TOTALL12M_TOTALLYTD_TOTALYTM_C2Y_TOTALACCOUNTABILITY_GROUP_NAMELY_L12M_TOTAL
14184221418279AsiaIndiaAlternative1985430Solar1985471Asia Pacific1985505Solar 1985507Alternative 1909120Solar Projects1920907Construction 193957942163947A2163947A0009,7223,12101,4530000014,2960000010,42111,30115,901018,53627,447083,607000000000000076,18121,7220Alternative 21,722
14184221418279AsiaIndiaAlternative1985430Solar1985471Asia Pacific1985505Solar 1985507Alternative 1909120Solar Projects1920907Construction 193957942170567B2170567B60,121020,60802,48022,83314,10200000120,14400000039,786221,375077,90783,2710422,3380000000000000502,69639,7860Alternative 39,786
14184221418279AsiaIndiaAlternative1985430Solar1985471Asia Pacific1985505Solar 1985507Alternative 1909120Solar Projects1920907Construction 193957942170597C2170597C0012,31100000000012,31100000015,42029,27027,864030,3730102,927000000000000099,81815,4200Alternative 15,420
14184221418279AsiaIndiaAlternative1985430Solar1985471Asia Pacific1985505Solar 1985507Alternative 1909120Wind Projects1920907Construction 193957942170659D2170659D42,24246,256105,45248,19816,570024,07400000282,79200000069,793124,469070,66634,22483,448382,5990000000000000595,59969,7930Alternative 69,793
anutosh_dhar
Contributor

Re: no relation dimension and detail

please help me.....

vinay_bangari
Valued Contributor III

Re: no relation dimension and detail

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.

anutosh_dhar
Contributor

Re: no relation dimension and detail

please find the attached files which contains sample data

anutosh_dhar
Contributor

Re: no relation dimension and detail

Hi vinay have you gone through my xls?

Community Browser