Discussion Board for collaboration on QlikView Layout & Visualizations.
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. :
the pivot should be :
I hope it's clear.
pls help me.
thx a lot.
Use below Expression.
Now u can get the 80% from Whole Count.
and in expression write this syntax
then output like this
ok, thx a lot, but my project is more complex(i know i didn't said in the first example), see attached file please.
here it's column ta_1 too.
this column is a pre-calculated time on db, now i need to do the avg of this value only of 80% of records grouped by data in my pivot table.
It's no good unfortunatly.....
try to make a filter on data 03/01/2013 you'll have these results :
count = 8
avg = 15.7 (this is the result of sum of ten ta_1 values divided by count of id)
count = 8
avg = 19.25 (this is the result of avg of first 8 record - 80% of 10 - divided by count of first 8 record )
i can't do the avg of first 8 record (80%)