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
Posted by at

3 comments:

  1. music4317 September 2013 at 12:48

    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. Stephen Redmond17 September 2013 at 13:14

    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. music4318 September 2013 at 08:36

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

      Delete

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

Subscribe to: Post Comments (Atom)