Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

michael_andrews
New Contributor III

Find average in drill down

Hi, I'd like to find the average of these items I have drilled down. If you look at this data

sum.png

I want to find the percentages (even though the column name is average score) here is what i have

//Count ItemID gets me 318

COUNT(ItemID) / COUNT({<ItemName = {"=ItemName"}>} ItemID)

Basically, I need to count all items that have the same parent item name

1 Solution

Accepted Solutions
MVP
MVP

Re: Find average in drill down

or this if you want the percentage to stay intact if you make a selection in ItemResponse

Count(ItemID)/Count(TOTAL <ItemName> {<ItemResponse>} ItemID)

3 Replies
MVP
MVP

Re: Find average in drill down

May be like this

Count(ItemID)/Count(TOTAL <ItemName> ItemID)

MVP
MVP

Re: Find average in drill down

or this if you want the percentage to stay intact if you make a selection in ItemResponse

Count(ItemID)/Count(TOTAL <ItemName> {<ItemResponse>} ItemID)

michael_andrews
New Contributor III

Re: Find average in drill down

You are the man. Helping me hit a deadline in an hour. Thanks!