10 Replies Latest reply: Jul 4, 2011 1:49 AM by seyma RSS

    Showing The Related Field For the max ID

      Hello everyone,

       

      I am new to qlikview development and I am stucked at this question , would appreciate your feedback,

       

      I have two datasources ;

      Data Souce 1
      Ins NoName
      450001Asım Akın
      450002Şeyma Can
      450003Ali Alkan
      450004Özsev Ateş

       

      Data Source 2
      Ins NoTelex IDTelex Num
      4500014500011AB1
      4500012AB2
      4500013AB3
      4500024500021BC1
      4500022BC2
      4500034500031CD1
      4500044500041DE1
      4500042DE2

       

      I need to create a table showing Ins No, Name, and Telex Num of the Max(TelexID) for that Ins No like in the table below,

       

      Ins NoKişi AdıTelex Num
      450001Asım AkınAB3
      450002Şeyma CanBC2
      450003Ali AlkanCD1
      450004Özsev AteşDE2

       

      I could not get that Telex Num to the table chart. Can you show me how to do it?

       

      Thank you