Chart IF statement for a selected value

Anonymous — Tue, 21 Aug 2018 11:57:59 GMT

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 want to populate SIM_ Rate based on a year.

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

topic Chart IF statement for a selected value in QlikView