I just started using the Microsoft Internet Explorer-based Version of QlikView (Version 11) and need your help with a calculation in a table.
I have defined a table with the columns "Month", "Business Unit", "Count" and "%" as follows:
The column "Month" shows the last three month of the report, the "Count" shows all customer-calls of a business unit. The column "%" needs to show the results of the calculation "Count" per "Business Unit" per "Month" divided by the total "Count" of all "Buiness Units" per "Month" (e.g.: 6/1947 = 0,31%).
As I could not figure out the correct code to realize this calculation, I have implemented a static caluclation that works for one month only:
This solutions provides the correct calculations for the last month (customer calls per business unit per month divided by total customer calls per month).
However, now I need an expansion of this formular to include the last three month. I cannot just type "-3" in the formular as this will result in an overall calculation of the percentage of three months.
Is this something I can solve by setting a condition on my dimension "Month"?
Your set analysis expression is evaluated only once for the entire chart, NOT per row. So you can't use it to calculate per month percentages for more than one month at a time. Use count(Anzahl)/count(total <Month> Anzahl). If you want to show only the last three months, use a calculated dimension or dimension limits or select the months etc.