4 Replies Latest reply: Dec 7, 2010 8:25 AM by Maria.Delaney RSS

    Pivot table, calculated dimension, Set Analysis doesn't work but AGGR might? HELP!


      I'm really getting into this Qlikview stuff now, but that brings its own burden that you start to think everything is possible - But enough of my personal problems.

      Essentially I have information about projects in one table and against those projects resources are allocated by date in another table. Each project also has its own limit value above which resources can still be allocated but the Qlikview application must report the limit (and no more) - Simple so far?

      The limit however only applies to one type of resource and the other resource(s) are free to grow as large as they want (and should be reported as such).

      Just when you thought that was it, in steps the Finance people saying that there needs to be an overall (not project related) limit to the aforementioned resource - This limit overrides the first limit - For this I've used an input variable as this figure has been known to change...

      None of the above is the problem and I've managed to do these using AGGR and lots of IF's. My problem is with what I thought would be simplest part, totalling.... I need to add the total for the completely unlimited resource to the 'limited limited' resource figure as a grand total.

      I've tried different combinations of this for what seems like days now and I thought Set Analysis could help but it just throws errors everywhere (I think this might be because I'm using it in a calculated dimension on a pivot table???)

      Can anyone help as I've starting to dream about this now.... [:S]