# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Is there any Percentage calculation function available in Qlikview

hi community ,

I am new to qlikview , so facing some problem . currently using a personal edition and wanted to know that is there any Percentage calculation function is available in personal edition , currently using a pivot table and wanted to add one more column in it which will so the percentage value next to some other column like :

---------------------------

value1 |   %value1

value2 |   %value2

value3 |   %value3

Regards

Ravindra Mandre

1 Solution

Accepted Solutions
Not applicable

## Re: Is there any Percentage calculation function available in Qlikview

Hi Ravindra,

I've attached the sample data (Excel sheet).

Just try a new application with the following dimensions and expressions.

Dimension

State,Region

Expression

Sales = sum(sales)

% Sales = Sum (Sales)/sum(total<State>Sales)

then u ll get the pivot table which is similiar to the table in the png image file which i have attached.

hope it ll help u.

Thanks & Regards,

4 Replies
Not applicable

## Re: Is there any Percentage calculation function available in Qlikview

Hi Ravindra,

Hope it helps...

Thanks & Regards,

Not applicable

## Is there any Percentage calculation function available in Qlikview

Hi  Arun ,

Thanks for the reply , but I am not able to open this file , request you to , if you can share logic on screen here, would be helpful for me.

Regards

Ravindra Mandre

Not applicable

## Re: Is there any Percentage calculation function available in Qlikview

Hi Ravindra,

I've attached the sample data (Excel sheet).

Just try a new application with the following dimensions and expressions.

Dimension

State,Region

Expression

Sales = sum(sales)

% Sales = Sum (Sales)/sum(total<State>Sales)

then u ll get the pivot table which is similiar to the table in the png image file which i have attached.

hope it ll help u.

Thanks & Regards,

Not applicable

## Is there any Percentage calculation function available in Qlikview

Hi Arun ,

Thank you very much for your help.

much appreciated

Regards

Ravindra Mandre

Community Browser