Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You must have common key fields in both table. You can add the year on the second table.
Best Regards.
Hi Anutosh can you put that data in the excel sheet so that it will be easy for understanding.
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 |
please help me.....
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.
please find the attached files which contains sample data
Hi vinay have you gone through my xls?