Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

How do I average certain criteria only?

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. 

Labels (1)
1 Solution

Accepted Solutions
m_woolf
Master II
Master II

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

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

View solution in original post

4 Replies
m_woolf
Master II
Master II

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

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

View solution in original post

knightwriter
Creator III
Creator III
Author

thank you 

knightwriter
Creator III
Creator III
Author

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

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.