Percentage of another function in pivot table

[#1]

Hello-

I am fairly new to qlikview and i am trying to fix the below issue:.

Below is my pivot chart in qlikview. I want to make the percentage as a function of the total carton count per time.

Here is an example:

For time as 0, on time as late and carton count as 449. The percentage should be 449/ 1136.

For time as 0, on time as on time and carton count as 687- the percentage should be 687/ 1136.

Time	On Time Performance	Carton Count	Percentage
0:00:00	Late	449	100%
0:00:00	On Time	687	100%
0:00:00	Total	1136	100%

I also have this chart repeat with different times (ex. 1, 2, 3, 4) and I want the same expression to follow the same logic.

Please let me know if you could help.

Thanks.

[jagan]

Hi,

Try like this

=Sum(CartonCount)/Sum(TOTAL <TimeDimensionName> CartonCount)

Note : CartonCount and TimeDimensionName with your actual dimension names.

Regards,

Jagan.

[#3]

Hi-

Thanks for the help. It was the correct expression-- i just needed to tweak it with different fields to get it to work.

Regards,

[jagan]

Hi,

If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.