Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage of another function in pivot table

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.

TimeOn Time PerformanceCarton CountPercentage
0:00:00Late449100%
0:00:00On Time687100%
0:00:00Total1136100%

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.

3 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

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


Note : CartonCount and TimeDimensionName with your actual dimension names.


Regards,

Jagan.

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.