topic Re: set analysis assistance in QlikView

set analysis assistance

davyqliks — Sat, 16 Nov 2024 01:45:58 GMT

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 — Thu, 05 Dec 2019 17:32:02 GMT

can you attach a sample?

and what is your expected output?

sergio0592 — Thu, 05 Dec 2019 20:42:28 GMT

Hi,

Maybe try with

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

davyqliks — Fri, 06 Dec 2019 14:13:14 GMT

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 — Fri, 06 Dec 2019 14:16:09 GMT

Thank you for the reply,

I just got round to looking and the suggestion worked.

Thank you for looking

Daniel