Help with expression (if condition)

[#1]

Hi Friends,

I have a 'calender' table having years from 1900 to 2999.

This calender table is joined with another table (Say A) by a key (Say A_key)

This table A is joined to my fact table (Say B) by a key (Say B_key) --so basically its a snow-flake kind of connection to calender table.

Table B contains information related to candidate responses to a set of questions, and main metrics is sum(candidate_response)

Now the requirement is, as a filter, we need to show the "Year"

When i simply add a list box for year, it shows all the values from 1900 to 2999

I dont want this. I want to show in the "Year" filter, only those values which have sum(candidate_response) >0 (or simply put..those Years which are relevant and has informative data associated with it)

The expression which i tried in "Year" listbox was this =if(sum({<Year>}candidate_response)>0,Year)

This did not work. Can any experienced guys help me here.

Thanks,

Vishnu

[#2]

Hi this seems to be a simple stuff. Just waiting for help from you

The expression =if(sum({<Year>}candidate_response)>0,Year) is not working

[muniyandi]

Hi Vishnu,

just wrote inline use same name.

This Attachment file is help for you.

by

Muni

[#4]

Do you need to have all those years in your Calender table?

If not, filter the unwanted values as part of your script.

To do this, create the Calendar table from Table A, or use Where Exists on the Year.

[sivarajs]

using set inside if condition wont work, try without using it

[perumal_41]

Hi ,

if(sum({<Year=>}candidate_response)>0,Year)  try this Expression .if not working ,please upload sample file

for reference .

Regards

Perumal A