Wednesday 26 June 2013

Win a copy of QlikView for Developers Cookbook

Packt have kindly agreed to give away 2 copies of my book.  See the competition page for details:

Stephen Redmond is author of QlikView for Developer's Cookbook
He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond


  1. Hi Stephen. Having bought your book, I have a question about Chptr 4 showing only the top 3 values in a pivot table. In your example, what formula would you use to calculate the subtotal outside of the pivot table. Assuming you had excluded the 'Others' group to give 20,318. Thx

  2. Hi,

    Try this:

    =Sum({<Country={'$(=Concat(If(Aggr(Rank(total Sum(Sales)), Country)<=3, Country, Null()), chr(39) & ',' & chr(39)))'}>} Sales)



    1. ...And that is why you are where you are. Pure genius!! And that was astonishingly fast. Thank you immensely. Oli


Note: only a member of this blog may post a comment.