topic Re: How do I average certain criteria only? in QlikView

How do I average certain criteria only?

knightwriter — Sat, 16 Nov 2024 01:08:25 GMT

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.

Re: How do I average certain criteria only?

m_woolf — Tue, 03 Mar 2020 19:51:30 GMT

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

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

Re: How do I average certain criteria only?

knightwriter — Wed, 04 Mar 2020 11:38:31 GMT

thank you

Re: How do I average certain criteria only?

knightwriter — Wed, 04 Mar 2020 12:05:30 GMT

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

Re: How do I average certain criteria only?

Brett_Bleess — Wed, 01 Apr 2020 21:01:32 GMT

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.htm

Regards,
Brett