0 Replies Latest reply: Jul 30, 2013 8:04 AM by Alessandro Bettica RSS

    top percent in qlikview

    Alessandro Bettica

      Hi guys,

       

      i've a big problem and i don't know how to solve it.

       

      I'll try to describe the problem :

       

       

      I've a database with a tree milions of record and i need to create a pivot table group by a data and apply a count of records(it's seem to be easy till now....)

      the count should be only on 80% of records for each data showed on pivot table(something like top percent in sql but grouped by data), i.e. :

       

      data               id

      01/01/2013     100

      01/01/2013     101

      01/01/2013     102

      01/01/2013     103

       

      02/01/2013     104

      02/01/2013     105

      02/01/2013     106

       

      03/01/2013     107

      03/01/2013     108

      03/01/2013     109

      03/01/2013     110

      03/01/2013     111

      03/01/2013     112

      03/01/2013     113

      03/01/2013     114

      03/01/2013     115

      03/01/2013     116

       

      the pivot should be :

       

      01/01/2013     3

      02/01/2013     2

      03/01/2013     8

       

      I hope it's clear.

       

      pls help me.

       

      thx a lot.

       

      bye.