set analysis assistance

[davyqliks]

Hi,

I have the following expression

sum({<[Year]={'2019'}>}[HKD_Price])

I am trying to fix this to a list of 'Location' including CHK CTH CVN

{<Location={CHK, CTH,CVN }>

but i cannot link the 2 'sets' together

here is my effort but it returns no value

sum({1{<[Year]={'2018'}, [Location] = {'CHK', 'CTH', 'CVN', 'CSG','CYY', 'CHZ', 'CIN'}>} [HKD_Price])

Can anyone advise on how this set expression would be written.

Thank you in advance for your time and help.

Daniel

[Chanty4u]

can you attach a sample?

and what is your expected output?

[sergio0592 · Accepted solution]

Hi,

Maybe try with

sum({1<[Year]={'2018'}, [Location] = {'CHK', 'CTH', 'CVN', 'CSG','CYY', 'CHZ', 'CIN'}>} [HKD_Price])

[davyqliks]

Hi Sergio,

Thank you so much.....Can't believe i only was a single curly bracket out. Getting better though!

Thanks for your help and time. Much appreciated.

Daniel

[davyqliks]

Thank you for the reply,

I just got round to looking and the suggestion worked.

Thank you for looking

Daniel