Escaping apostrophe in if statement

[Anonymous]

I have declared a variable vYear_Quarter as follows

    =if(vSelectionValue = 2017,'2017/Q1, 2017/Q2, 2017/Q3, 2017/Q4',

        if(vSelectionValue = 2018,'2018/Q1,2018/Q2'))

The above expression returns vYear_Quarter = 2017/Q1, 2017/Q2, 2017/Q3, 2017/Q4 if I select year 2017 and

vYear_Quarter = 2018/Q1,2018/Q2 if I select year 2018

.But I want to get the value vYear_Quarter in a such a way that it could be fed to a set expression

    =sum({<"YearQ"={'$(vYear_Quarter )'}}>}AMOUNT)

But with the if statement i am not able to get the value of vYear_Quarter  in the form such as '2018/Q1','2018/Q2'

I want 2018/Q1 and 2018/Q2 in apostrophe and seperated by comma

[sunny_talwar · Accepted solution]

Try this may be

=If(vSelectionValue = 2017, Chr(39) & '2017/Q1' & Chr(39) & ',' & Chr(39) & '2017/Q2' & Chr(39) & ',' & Chr(39) & '2017/Q3' & Chr(39) & ',' & Chr(39) & '2017/Q4' & Chr(39),

If(vSelectionValue = 2018, Chr(39) & '2018/Q1' & Chr(39) & ',' & Chr(39) & '2018/Q2' & Chr(39)))

[Anonymous]

Amazing