Is there any Percentage calculation function available in Qlikview

[#1]

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

[#2]

Hi Ravindra,

Please check the attached application.

Hope it helps...

Thanks & Regards,

Arun Prasadh.N.

[#3]

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

[#4 · Accepted solution]

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.

[#5]

Hi Arun ,

Thank you very much for your help.

much appreciated

Regards

Ravindra Mandre