Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
qvraj123
Contributor II

Top 1 and TOp10 and TOp20 as dimension values

Hi

Thanks for your time - can someone pls suggest on how to get the hard coded dimension values based on the AGGR and Rank - I need Top1, Avg of Top10, Avg of Top 20 as dimension values - for each dimension value the measure need to be calculated

DimensionValue             Total Number of Publications,                                             Total Reads

TOp1                                      Top 1  based on distinct count of DocIDs                      Sum of reads

Avg of TOp10                   Avg of TOp10 based on distinct count of DocID           avg of sum of 10

Avg of TOp20                  Avg of TOp20 based on distinct count of DocID           avg of sum of 20

 

the dimension values are not in the data - these should be derived ones based on the top1, avg of top10 and avgof top20

attached some sample data

1 Reply
Partner
Partner

Re: Top 1 and TOp10 and TOp20 as dimension values

Hi!

Please, check the attached file.

regards,

Jaime.