topic Re: Unique record entry in QlikView

Unique record entry

Thu, 02 Aug 2012 17:13:57 GMT

Hi,

I have a table of items; these items can exist in multiple countries.

I need a table that shows only one line per item with three columns - one for English Descirption, German Description and French description. Essentially, I only want a table with four rows; currently I am getting twelve.

Any help would be appreciated; thanks in advance.

Re: Unique record entry

swuehl — Thu, 02 Aug 2012 17:39:00 GMT

Hi,

try

ItemsStep2:

Load

Item,

only(if(Country = 'UK', Description)) as UK_Description,

only(if(Country = 'Germany', Description)) as German_Description,

only(if(Country = 'France', Description)) as French_Description

resident ItemsStep1 group by Item;

DROP table ItemsStep1;

Re: Unique record entry

Fri, 03 Aug 2012 08:15:41 GMT

Awesome, thank you!