topic Re: Match function to solve? in QlikView

Match function to solve?

n1ef5ng1 — Thu, 27 Mar 2014 09:36:03 GMT

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)

Re: Match function to solve?

n1ef5ng1 — Mon, 31 Mar 2014 04:09:35 GMT

anybody can help

Re: Re: Match function to solve?

n1ef5ng1 — Mon, 31 Mar 2014 04:41:17 GMT

Attached file example.

Re: Match function to solve?

jonathandienst — Mon, 31 Mar 2014 05:32:45 GMT

If the two files contain the same or similar sets of data, I would concatenate them into a single file. If the field names differ, then you will need to alias the fields in one or both of the load statements to align them. Something like:

LOAD

...

Market_Country As Country,

AnotherField As Another,

...

From Table1;

LOAD

...

Market_Country_TXIT As Country,

[Some Other Field] As Another,

...

From Table2;

HTH

Jonathan

Re: Match function to solve?

n1ef5ng1 — Mon, 31 Mar 2014 05:43:39 GMT

I am unable to edit script, able to do it through edit expression