topic Re: Expression to pull through data only if it matches with criteria within selected field in App Development

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

JoshT — Tue, 18 Oct 2022 16:40:59 GMT

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')

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

maxgro — Tue, 18 Oct 2022 17:19:50 GMT

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/SetAnalysis/set-analysis-expressions.htm

or here

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

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

JoshT — Fri, 21 Oct 2022 08:52:27 GMT

Ah amazing - thank you this worked.

Josh