Expression to pull through data only if it matches with criteria within selected field

[JoshT]

Hi,

Hopefully someone can please help with this.

I am new to Qlik and just starting to work with expressions.

I am using the KPI chart to pull through an average of specific metric of data I have in my excel sheet. I want to only pull through data from the revenue column IF it has '2021/22' for the FY(financial year) column. See below.

And then this is pulled through into the KPI visual.

This is what I have tried but it doesnt work - =avg([Revenue YoY % Growth])if(FY='2021/22')

[maxgro]

try with

avg({$<FY={'2021/22'}>} [Revenue YoY % Growth])

a brief explanation can be found here

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnal...

or here

https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-syntaxes-examples/ta-p/1491810

[JoshT]

Ah amazing - thank you this worked.

Josh