Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH 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.