13 Replies Latest reply: Jul 6, 2015 9:05 AM by Sinan Ozdemir RSS

    need help for Lookup function

    tarun bisen

      Dear all,

       

      I need help regarding the lookup function as their was many help regarding this.

       

      but my query is different but regarding the lookup in single table.

       

      I am trying to add  column price 2 by surcharging from price 1 through factory_godown in godown to godown column and putting the price 1 value in the chart.

       

      I am Attaching the base file which is created by qlik view.

      Required table in qlik view chart 

       

      Cement_Flowfactory_godownGodown to GodownpicsAMOUNTprice1price 2price 1+2
      F-G201L416L3,8022,634,087.006930693
      F-G202K407K6,5251,827,000.002800280
      F-G202K411K11,9303,556,924.002980298
      F-G202K473K3,9383,084,132.007830783
      F-G203M427M6,6932,529,729.503780378
      F-G209C473C3,8225,633,896.001,47401,474
      F-G209C535C4,6262,640,576.005710571
      F-G209C537C7,6674,938,180.006440644
      F-G209C542C4,0142,336,567.005820582
      F-G219B427B7,77010,525,860.001,35501,355
      F-G219B518B5,4433,334,484.006130613
      G-G407K401K245200,165.008172801,097
      G-G407K402K8157,753.00713280993
      G-G411K419K2512,500.00500298798
      G-G416L415L18956,700.00300693993
      G-G427B825B25863,210.002451,3551,600
      G-G427M825M33281,340.00245378623
      G-G473C410C800320,000.004001,4741,874
      G-G473L410L3012,000.004000400
      G-G518B517B171,819.00107613720
      G-G537C754C7833,228.004266441,070
      G-G542C419C32691,280.00280582862

       

      Message was edited by: Tarun Bisen I have done in excel file but the data is very huge for that it is not possible to do all tome i have shared a sample of data. now i am attaching the final excel report file where i  have done through using functions.