Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Please help me to solve it.

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,

Arun Prasadh.N.

4 Replies
Not applicable

Re: Is there any Percentage calculation function available in Qlikview

Hi Ravindra,

Please check the attached application.

Hope it helps...

Thanks & Regards,

Arun Prasadh.N.

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,

Arun Prasadh.N.

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