4 Replies Latest reply: Mar 31, 2014 1:43 AM by ben lim RSS

    Match function to solve?

    ben lim

      Hi all, I have two different main data table on my qlikview database.

      Throughput (Data) --> Market_Country (Dimension)

       

      Transit (Data) --> Market_Country_TXIT (Dimension)

       

      Basically this shows that these data are somehow not link to the country.

      This gives me the problem as when I tried to link both of them up in a table.

       

      In Market_Country and Market_Country_TXIT, this two tables shares the same content, basically countries all over the world.

      I would want to create a table that list out all the countries with expression on throughput and transit

       

      Group_Country_Code as Dimension with sum(Throughput) and sum(Transit) will give me correct value for throughput but not transit

      Group_Country_Code.Transit as Dimension with sum(Throughput) and sum(Transit) will give me correct value for transit but not throughput.

       

      Is there anyway I can merge, mix, grind, match, wildmatch Group Country Code and Group Country Code transit since both of them carry the same fields

       

      I tried Match(GroupCountryCode,GroupCountryCode.Transit,GroupCountryCode) but fail.

       

      any help ( i cnt edit script, have to do in dimension)