Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Unique record entry

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.

C

1 Solution

Accepted Solutions
MVP
MVP

Re: Unique record entry

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;

2 Replies
MVP
MVP

Re: Unique record entry

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;

Not applicable

Re: Unique record entry

Awesome, thank you!

Community Browser