Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternative to Concatenate

Hi ,

I have table as below

 

Date               PName   Producttype     MarketType   discount

2010/01             A             PC               Corporate      10%

2010/02             B             Server           Individual       15%

2010/03             B             Server           Corporate      15%

2010/04             B             Server            both             15%

Where both indicates the discount is for the Individual and corporate. I have a fact table with sales amount and i need to use this discount to calculate the profit.I understand in Qlikview we can split in to two tables and concatenate to Split the Both in to Corporate and Individual.

Is there any other way we can do it in QlikView. or Best practice as the Hisorical cdata will be keep incereasing.

Tags (2)