Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try like this
=Sum(CartonCount)/Sum(TOTAL <TimeDimensionName> CartonCount)
Note : CartonCount and TimeDimensionName with your actual dimension names.
Regards,
Jagan.
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,
Hi,
If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.
Regards,
Jagan.