IF Statement on to be done on a Selected Field

[Anonymous]

Hello,

I have a requirement to select a year which comes from the front-end and then execute an IF Statement in a chart.

For example when 2018 is selected go and get a particular value or else select 1.

I cannot for the life of me get this working.

This is my year selection:               SIMULATE.Sim_Year = GetFieldSelections(Calendrier.Année)

This is my IF Statement:                 if(Currency ='Local',SIMULATE.Sim_Rate,1)

I need to get the year of the Sim_Rate or the Year of 1.

I've tried various combinations and I cannot seem to get this to work.

SIMULATE.Sim_Year = '($(=GetFieldSelections(Calendrier.Année))', if( Currency ='Local', SIMULATE.Sim_Rate,1)

Any help would be greatly appreciated.

Paul

[pradosh_thakur]

Can you be more clearer

try this

if( Currency ='Local' and getfieldselections(Calendrier.Année)=2018, SIMULATE.Sim_Rate,1)

[gavinigovind452]

try this you are  selecting 1 value in SIMULATE.Sim_Year

if(SIMULATE.Sim_Year = '$(=GetFieldSelections(Calendrier.Année))' and Currency ='Local', SIMULATE.Sim_Rate,1)

Regards,

Govind

[shraddha_g]

Where do you want to use IF statement?

In set analysis?

[Anonymous]

Hi,

Thanks for your answer.

I need to get the value for the SIMULATE.Sim_Rate based on the selected year or else use 1 as the value (this is based on the currency)

Execute this statement

if(Currency ='Local', SIMULATE.Sim_Rate,1) for a year

[Anonymous]

Thanks for your answer.

I need to get the value for the SIMULATE.Sim_Rate based on the selected year or else use 1 as the value (this is based on the currency)

Execute this statement

if(Currency ='Local', SIMULATE.Sim_Rate,1) for a year

[agigliotti]

could you share  a sample app with mock data ?

[gavinigovind452]

please try it

if(SIMULATE.Sim_Year = '$(=GetFieldSelections(Calendrier.Année))' and Currency ='Local'  and getselectedcount(Calendrier.Année)>=1, SIMULATE.Sim_Rate,1)

[Anonymous]

Here is the app - I had to do it in QV - hope this is ok.

[agigliotti]

the field name "Currency" does not exists in data model !?