topic expression with multiple filters in App Development

expression with multiple filters

stekol61 — Fri, 10 May 2019 10:02:16 GMT

Hi!

I have loaded some data from an Excel.

I want to be able to get the value in'Limit(%)' for a specific 'Graph_num' and 'Country'.

I have used this expression but it doesn't find the correct 'Limit(%)'

What can be the problem?

=Sum({$<Graph_num={14}>}{$<Country={SE}>}[[Limit(%)])

lalphonso — Sat, 11 May 2019 03:05:18 GMT

You can combine your filters into one set expression like this:

=Sum({$<Graph_num={14},Country={"SE"}>}[Limit(%)])

Cheers,

lalphonso — Sat, 11 May 2019 03:10:38 GMT

Another way is to use it as a row level dimension ...

=if(Graph_num=14, if(Country="SE", [Limit(%)],0),0)

Cheers,