Qlik Only function with sub functions

[anwarbham]

hi , i am trying to limit a dimension based on the selected filter of year 

if some one selcts 2019 then i should only see 

records from 2019 

eg 

 01/01/2019 - 30/04/2019

i am trying to use the ONLY function to get only the records where the last 4 digits are 2019, but i get the error i can only use 1 parameter, Can anyone help with the syntax 

if (
GetCurrentSelections(Year) = '2019',

Only(right([Cycle Generic],4)= '2019',[Cycle Generic])

)

[Kushal_Chawda]

@anwarbham  may be try below

if (
GetCurrentSelections(Year) = '2019' and

right([Cycle Generic],4)= '2019',[Cycle Generic])

)

[anwarbham]

Thanks

this works but if i select both 2019 and 2020 it does not work regardless if i add a match([Cycle Generic], '2019','2020')

=if (
GetFieldSelections(Year) = '2019' and
right([Cycle Generic],4) = '2019'
,[Cycle Generic],

if(
GetFieldSelections(Year) = '2020' and 
right([Cycle Generic],4) = '2020',
[Cycle Generic]

))

[paulselousyoriz]

That is because if you select more than one Year, then GetFieldSelections(Year) will return the selected values with a comma inbetween, so in your example '2019,2020', which does not equal '2019' nor '2020'. You can solve this with a wildmatch with wildcard characters:

If(wildmatch(GetFieldSelections(Year),'*2019*','*2020*')>0 and
(right([Cycle Generic],4)='2019' Or right([Cycle Generic],4)='2020'),[Cycle Generic])

Hope that helps!

Paul