Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qv_testing
Valued Contributor II

Split Groupwise data in Pivot or Straight table

HI Community,

I have Straight table, Here i have ProductName, in ProductName i have many attributes.

My requirement i have to split product Group wise data..

Capture.JPG

Sample Example:    These 4 product names one group and remaining are another group.

ProductCategoryAmount
AAA Running ShoeBaby Clothes100
Aino ShoesChildren's Clothes200
Atles LussekoftaMen's Clothes300
Baby Dark Lounge SuitMen's Footwear400

Client wants only these names only,

I have taken one inline table..

Like:

Load * Inline [ 

MappField
AAA Running Shoe
Aino Shoes
Atles Lussekofta
Baby Dark Lounge Suit

];

But this is not associating to ProductName..

Any better Approach..??

Thanks in Advance....

1 Reply

Re: Split Groupwise data in Pivot or Straight table

May be you want something like this:

LOAD Product

          Category,

          Amount,

          If(Match(Product, 'AAA Running Shoe', 'Aino Shoes', 'Atles Lussekofta', 'Baby Dark Lounge Suit'), 'Group1', 'Group2') as Group

FROM Source;