Qlik sense create measures based on values in a column

[andewan]

I am new to Qlik Sense, and my question is fundamental.

If I have an input table with column 'Code' including several measure names, how can I create measures based on the values in the Code column? I need the measures to create other visuals, so a Pivot table visual is not what I am looking for.

Input table:

Code	Country	Amount
Asset	Spain	30
Asset	France	13
Asset	Australia	45
Loan	Spain	123
Loan	France	65
Loan	Australia	23

Requirement (new columns):

Country	Asset	Loan
Spain	30	123
France	13	65
Australia	45	23

Thanks in advance!

[ogster1974 · Accepted solution]

add the following set analysis into your measure as a master item for use elsewhere.

example

sum({<Code={'Asset'}>} Value) for Asset Value

sum({<Code={'Loan'}>} Value) for Loan Value

etc...

[andewan]

Thanks for the prompt response, Ogster 🙂