topic Re: Expression with multiple conditions in App Development

Expression with multiple conditions

Sat, 16 Nov 2024 10:34:50 GMT

Hey,

I'm building an expression which should work like this:
I have a data set which has columns for year, for amount and for item. I want to make the chart to show only the items which have their amount of year='2014' higher than year='1995'.

I've tried the following

IF(((year='1995' and "amount")<(year='2014' and "amount")), "item")

which was a long shot and didn't get me far.

Any help with the expression? Thanks.

Re: Expression with multiple conditions

narendiran — Tue, 14 Jun 2016 16:01:11 GMT

Hi,

This may be helpful

if(Sum({<Year={'1995'}>}amount)<Sum({<Year={'1995'}>}amount),'item')

Re: Expression with multiple conditions

swuehl — Tue, 14 Jun 2016 16:01:26 GMT

This is used in a calculated dimension?

=Aggr( If( Sum({<year = {1995}>} amount) < Sum({<year = {2014}>} amount), item), item)

Re: Expression with multiple conditions

sunny_talwar — Tue, 14 Jun 2016 16:16:08 GMT

May be like this in your expression:

Sum({<items = {"=Sum({<year = {2014}>} amount) > Sum({<year = {1995}>} amount)"}>} amount)

Re: Expression with multiple conditions

Thu, 16 Jun 2016 00:03:28 GMT

Thanks for all. This did the trick at once - perfect!