Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Ravindra,
Please check the attached application.
Hope it helps...
Thanks & Regards,
Arun Prasadh.N.
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
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.
Hi Arun ,
Thank you very much for your help.
much appreciated
Regards
Ravindra Mandre