How do I average certain criteria only?

[knightwriter]

Hi ,

Ive a list of fruit in one column and a list of prices in another. How do I create a text box object with say for example the average of apple prices only?

Secondly, how do I round numbers in a chart? ie $120,000 to $120k.

Many thanks. 

[m_woolf · Accepted solution]

avg({<Fruit={'Apple'}>}Price)

For the number formatting, look in Properties|Number at the Thousand Symbol box.

[knightwriter]

thank you 

[knightwriter]

apologies - for the thousand symbol, do I  put an expression in this box and divide by 1000?

[Brett_Bleess]

Here is a Design Blog post that may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

In regard to the number rounding, have you checked out the Number tab settings of your chart?  That should allow you to set things:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Number_Chart.ht...

Regards,
Brett