Good morning Qlik community,
I just wanted to reach out and see if this data layout would be possible in a pivot or straight table?
Only month, and full-year are available as raw-data. A simplistic version of what I need is attached, but I can only get the first column (month) to function properly. This version is not my full qlikview, due to sensitivity of data, I cannot post that one. Nevertheless, I can provide the data model.
The biggest issue I am running into is that since a lot of my KPI's are %-based, they need to be computed on the fly to avoid avg(%) which isn't correct, since it is not a weighted average. For instance, my sixth KPI is this expression:
SUM(KPI_DWHOPI_BIZ_HOURS_ADJ_DEALS_REVIEWED) /
(sum(KPI_DWHOPI_DEALS_APPROVED_W_COND) + sum(KPI_DWHOPI_DEALS_APPROVED_WO_COND) + sum(KPI_DWHOPI_DEALS_REJECTED))
Also, I should state, a requirement is that YTD is based on the month's selection; so you could for instance click Feb, and it does a YTD of Jan-Feb; not YTD based on the current date (my data is monthly based, not daily).
Thank you for your assistance,
-Mikael