2 Replies Latest reply: Feb 6, 2012 11:50 AM by Alexandre POTTIER RSS

    how to search same value in different columns and differents lign row

      Hi Guys,

       

      I want use Qlikview for bank reconciliation, i explain :

       

      I have two columns, Column A and Column B

       

      In my columns, i have many numbers. The sum of numbers in column A must be equal of the sum of numbers in column B.

       

      I can have several times the same number in one column, but carreful, number in column A is not everytime at the same row in column B.

       

      I need Qlikview search the number to column A in all of the column B, and if the occurence of one number in column A is superior or inferior of the occurence in column B, Qlikview do something (do a color, or give the number, no matter)

       

      I give a example (fake numbers of course) :

       

       

      Colonne AColonne B
      1030
      2025
      3010
      1045
      3010
      6065
      7075
      1085
      9010
      10010

       

      You see for example, the number 10 have 3 occurences in A, 4 occurence in B. I need Qlikview say to me the number 10 have one occurence in too in the B column.

       

      Can you help me ?

       

      The same in excel file.

       

      Thanks