topic Re: Percentage of another function in pivot table in QlikView

Percentage of another function in pivot table

Sun, 19 Oct 2014 23:28:24 GMT

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.

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 — Mon, 20 Oct 2014 02:06:36 GMT

Hi,

Try like this

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

Note : CartonCount and TimeDimensionName with your actual dimension names.

Regards,

Jagan.

Mon, 20 Oct 2014 19:37:53 GMT

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 — Tue, 21 Oct 2014 01:31:20 GMT

Hi,

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

Regards,

Jagan.