topic Re: Is there any Percentage calculation function available in Qlikview in QlikView

Is there any Percentage calculation function available in Qlikview

Wed, 14 Dec 2011 05:34:23 GMT

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

Re: Is there any Percentage calculation function available in Qlikview

Wed, 14 Dec 2011 06:12:28 GMT

Hi Ravindra,

Please check the attached application.

Hope it helps...

Thanks & Regards,

Arun Prasadh.N.

Is there any Percentage calculation function available in Qlikview

Wed, 14 Dec 2011 06:37:51 GMT

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

Re: Is there any Percentage calculation function available in Qlikview

Wed, 14 Dec 2011 07:05:34 GMT

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.

Is there any Percentage calculation function available in Qlikview

Wed, 14 Dec 2011 07:42:01 GMT

Hi Arun ,

Thank you very much for your help.

much appreciated

Regards

Ravindra Mandre