topic Re: Count total matches in QlikView

Count total matches

ankit777 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have data like this

Match ID COMP1 COMP2

1 Team1 Team2

2 Team2 Team3

3 Team3 Team1

...

I want to show in a graph, How many matches each team has played.

How can I achieve this.

Thanks

Re: Count total matches

Anonymous — Tue, 25 Apr 2017 18:09:10 GMT

load a flag in the script:

LOAD if(COMP1=COMP2,1) as FLAG...

then

do a count(FLAG) in the chart

Re: Count total matches

ankit777 — Tue, 25 Apr 2017 18:15:24 GMT

How can COMP1 be equal to COMP2?

There will be 2 different teams playing a match

Re: Count total matches

agni_gold — Tue, 25 Apr 2017 18:16:14 GMT

Load Match,Comp1 AS Company;

LOAD * INLINE [

Match, Comp1

1, Team1

2, Team2

3, Team3

];

Concatenate

Load Match,Comp2 AS Company;

LOAD * INLINE [

Match, Comp2

1, Team2

2, Team3

3, Team1

];

Re: Count total matches

Anonymous — Tue, 25 Apr 2017 18:19:40 GMT

LOAD COMP1 as COMP resident Yourtable;

concatenate

LOAD COMP2 as COMP resident Yourtable;

then count(COMP) in the chart / script and COMP as dimension

Re: Count total matches

sunny_talwar — Tue, 25 Apr 2017 18:22:16 GMT

May be using a link table approach

Table:

LOAD * Inline [

Match ID, COMP1, COMP2

1, Team1, Team2

2, Team2, Team3

3, Team3, Team1

];

LinkTable:

LOAD [Match ID],

COMP1 as Team,

'Comp1' as Flag

Resident Table;

Concatenate(LinkTable)

LOAD [Match ID],

COMP2 as Team,

'Comp2' as Flag

Resident Table;

Re: Count total matches

agni_gold — Tue, 25 Apr 2017 18:24:02 GMT

hey Ankit , i think this you want ,

Directory;

CrossTable(Comp, Team)

LOAD Match,

Comp1,

Comp2

FROM

[New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Transpose()

));