using "Max" in an expression

[Anonymous]

Hi

I have the following table in Qlikview.

Account     AccountName     ProductName    

050250       Tennisan                Apples

050250     Tennisan              Oranges

059300     Geoarges              Apples

But I only want Tennisan to show up once with Oranges, Apples as the ProductName.  Is this possible?

Like this:-

Account     AccountName     ProductName    

050250     Tennisan              Apples, Oranges

059300     Geoarges              Apples

Cheers,

LC

[MindaugasBacius]

How did you decide that the Account should be 050250 not 50250?

[Anonymous]

whoops.  typo.  ive updated

[Gysbert_Wassenaar]

Use Account and AccountName as dimensions and as expression Concat(Distinct ProductName).

[sunny_talwar]

I guess it is a typo... I would do something like this:

LOAD Account,

          AccountName,

          Concat(ProductName) as ProductName

FROM .....

Group By Account, AccountName;

[MindaugasBacius]

Table:
Load AccountName
  ,ProductName
  ,Text(Account) as Account
Inline [
Account,     AccountName,     ProductName    
50250,       Tennisan,                Apples
050250,     Tennisan,              Oranges
059300,    Geoarges,              Apples
];


QUALIFY *;
tmb:
LOAD AccountName
  ,Concat(ProductName, ',') as ProductName
Resident Table
Group By AccountName
;
UNQUALIFY *;

The result:

[Anonymous]

Hi Sunny,

I've added Concat(ProductName) as ProductName to my script.

I'm getting the following error when uploading the attached:-

OLEDB read failed

[sunny_talwar · Accepted solution]

I think you missed the Group By statement.

Entitlements:

LOAD.....

Group By Account, AccountNumber;

Select .....

[Anonymous]

Thanks Sunny