Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
avg({<Fruit={'Apple'}>}Price)
For the number formatting, look in Properties|Number at the Thousand Symbol box.
avg({<Fruit={'Apple'}>}Price)
For the number formatting, look in Properties|Number at the Thousand Symbol box.
thank you
apologies - for the thousand symbol, do I put an expression in this box and divide by 1000?
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:
Regards,
Brett