Expression with multiple conditions

[#1]

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.

[narendiran]

Hi,

This may be helpful

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

[swuehl · Accepted solution]

This is used in a calculated dimension?

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

[sunny_talwar]

May be like this in your expression:

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

[#5]

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