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:

http://www.qliktips.com/p/competition.html



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

3 comments:

  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

    ReplyDelete
  2. Hi,

    Try this:

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


    Regards,


    Stephen

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

      Delete