Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Market Share Calculation

Team,

I am looking for the below calculations. I am pretty new to Qlikview.

I have got the following fields

Company      PrevYearSales          CurrYearSales          PrevYearMarketShare          CurrYearMarket Share

     A                  3.2                         5.2                         10 / 3.2                              13 / 5.2

     B                  4.5                         4.8                         10 / 4.5                              13 / 4.8

     C                  2.3                         3.0                         10 / 2.3                              13 / 3.0

Total                 10.0                        13.0

How do I define the calculations for the last two columns? I am not able to access the Total of the sales columns.

The sales columns are calculated fields and are defined as expressions.

Please advise.

Regards,

Sudha

0 Replies