12 Replies Latest reply: Oct 23, 2017 5:17 AM by Agrim Sharma RSS

    how to select data if tables are placed below main data table.

    Agrim Sharma

      Hi All,

       

      i have an situation, in which i have an excel file but the tables are placed below each other in single Sheet, example:-

       

      Table1

      individual
      MonthForecast CAPEXForecast GFCInitial CAPEXInitial GFCdata1
      K4/001.2017£          351,840.39£          161,404.15£          411,796.33£          830,542.85data1
      K4/002.2017-£            23,825.13£          605,939.63£          411,796.33£          865,333.76data1
      K4/003.2017£          110,052.36£          585,895.14£          491,082.05£          941,313.55data1
      K4/004.2017£          322,454.35£          428,243.72£          631,082.05£          904,825.76data1
      K4/005.2017£          260,671.63£          575,122.00£          723,224.90£          822,679.81data1
      K4/006.2017£          493,642.98£       1,425,998.98£          723,224.90£          729,776.15data1
      K4/007.2017£          236,819.45£          781,265.11£          666,558.24£          661,859.49data1
      K4/008.2017£          403,994.86£          580,229.74£          652,358.24£          560,359.49data1
      K4/009.2017£          422,676.14£          683,787.10£          977,358.24£          529,258.65data1
      K4/010.2017£          519,878.12£          690,975.25£          795,639.19£          472,310.26data1
      K4/011.2017£       1,627,117.27£          673,013.13£          795,639.19£          457,185.26data1
      K4/012.2017£       2,054,316.31£          978,765.76£          793,496.33£          441,220.97data1

       

      Table2

      Cumulated
      MonthForecast CAPEXForecast GFCInitial CAPEXInitial GFCdata2
      K4/001.2017£          351,840.39£          161,404.15£          411,796.33£          830,542.85data2
      K4/002.2017£          328,015.26£          767,343.78£          823,592.67£       1,695,876.62data2
      K4/003.2017£          438,067.62£       1,353,238.92£       1,314,674.71£       2,637,190.16data2
      K4/004.2017£          760,521.97£       1,781,482.64£       1,945,756.76£       3,542,015.93data2
      K4/005.2017£       1,021,193.60£       2,356,604.64£       2,668,981.67£       4,364,695.74data2
      K4/006.2017£       1,514,836.58£       3,782,603.62£       3,392,206.57£       5,094,471.89data2
      K4/007.2017£       1,751,656.03£       4,563,868.73£       4,058,764.81£       5,756,331.38data2
      K4/008.2017£       2,155,650.89£       5,144,098.47£       4,711,123.05£       6,316,690.87data2
      K4/009.2017£       2,578,327.03£       5,827,885.57£       5,688,481.29£       6,845,949.52data2
      K4/010.2017£       3,098,205.15£       6,518,860.82£       6,484,120.48£       7,318,259.77data2
      K4/011.2017£       4,725,322.42£       7,191,873.96£       7,279,759.67£       7,775,445.03data2
      K4/012.2017£       6,779,638.73£       8,170,639.72£       8,073,256.00£       8,216,666.00data2


      Table3

      Difference

      MonthCAPEX differenceGFC Differencedata3
      K4/001.2017-£            59,955.94-£          669,138.70data3
      K4/002.2017-£          495,577.41-£          928,532.84data3
      K4/003.2017-£          876,607.09-£       1,283,951.24data3
      K4/004.2017-£       1,185,234.79-£       1,760,533.29data3
      K4/005.2017-£       1,647,788.07-£       2,008,091.10data3
      K4/006.2017-£       1,877,369.99-£       1,311,868.27data3
      K4/007.2017-£       2,307,108.78-£       1,192,462.65data3
      K4/008.2017-£       2,555,472.16-£       1,172,592.40data3
      K4/009.2017-£       3,110,154.26-£       1,018,063.95data3
      K4/010.2017-£       3,385,915.33-£          799,398.95data3
      K4/011.2017-£       2,554,437.25-£          583,571.07data3
      K4/012.2017-£       1,293,617.27-£            46,026.28data3

       

       

      how can i select only "table2" and "table3" from one sheet of excel in Qlik Sense?


      Regards