topic Re: Leauge match Display in QlikView

Leauge match Display

Mon, 24 Feb 2014 12:13:13 GMT

Hi,

I have excel sheet with two tabs.

Team sheet have all team which are participating.

League sheet have league matches with opponent.

Now I want to display league sheet by selecting list box

for example

if I select WAKFIELD or PETERBORUGH from List box it supposed to show me data from League sheet.

Regards

Vinay

Re: Leauge match Display

hic — Mon, 24 Feb 2014 12:34:39 GMT

League:

LOAD RecNo() as GameID,

Team1,

Goal as Goal1,

Team2,

Goal1 as Goal2

FROM Team.xlsx (ooxml, embedded labels, table is League);

Teams:

Load GameID,

Team1 as Team

Resident League;

Load GameID,

Team2 as Team

Resident League;

It is in fact very similar to a Canonical Date, although it concerns teams and not dates.

HIC

Re: Leauge match Display

MK_QSL — Mon, 24 Feb 2014 12:47:56 GMT

May be like this...

TEAM:

LOAD Teams as Team1

FROM

Team.xlsx

(ooxml, embedded labels, table is Team);

TABLE1:

LOAD Team1,

Goal,

Team2,

Goal1

FROM

Team.xlsx

(ooxml, embedded labels, table is League);

Concatenate

LOAD Team1 as Team2,

Goal as Goal1,

Team2 as Team1,

Goal1 as Goal

FROM

Team.xlsx

(ooxml, embedded labels, table is League);

Re: Leauge match Display

Mon, 24 Feb 2014 12:56:40 GMT

Thanks Henric & Manish. Its work. I appreciated your help.

Thanks

Vinay