topic Pivot Table Ratio in QlikView

Pivot Table Ratio

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Good Day.

I want to create a pivot table with one dimension and two expression. dimension is airline name and the expressions are incentive and percentage of incentive.

I have attached the format. My Dimesnion is airplane_name and expressions are sum(TICKET_INC) and SUM(TICKET_INC)/ SUM(Total TICKET_INC)

I want to remove some airlines that i have written a condition in the dimension, but when i give the option suppress when value is null, i am not getting the 100% in total ration.

Could any one let me know whats the solution..

thanks and Regards

Re: Pivot Table Ratio

MK_QSL — Sun, 24 Apr 2016 08:22:58 GMT

What is the condition you have written in Dimension?

Without knowing that, It is difficult to give you answer..

Re: Pivot Table Ratio

Gysbert_Wassenaar — Sun, 24 Apr 2016 08:28:44 GMT

Try these expressions:

SUM({<airplane_name={'*'}>}TICKET_INC)
SUM({<airplane_name={'*'}>}TICKET_INC)/SUM({<airplane_name={'*'}>}Total TICKET_INC)

Re: Pivot Table Ratio

Sun, 24 Apr 2016 08:37:06 GMT

Kindly find it as closed!

Re: Pivot Table Ratio

qliksus — Mon, 25 Apr 2016 09:38:07 GMT

If you are using a Straight table with the relative option checked this should work automatically

Or you may use the expression suggested above