Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
)
@anwarbham may be try below
if (
GetCurrentSelections(Year) = '2019' and
right([Cycle Generic],4)= '2019',[Cycle Generic])
)
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]
))
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