Dimension value in a modifier

[jeevays7]

Hi All,

The below is the data source table:

Class	Value
Fx	100
Fx	200
Cash	50
Cash	50
Equity	250

Now i need to show table like below:

NAME	Value
Fx	300
Cash	100
Commodity	0
Equity	250
Others	0

in the above table NAME is a inline field i have created.

i need to write expression like :

Sum({<Class=NAME>}Value) in Value field in the above table.

How can i do this? i am not able to pass the NAME field value for Class field in set analysis.

Please help me

[vikasmahajan]

While loading data in your script  change Class to NAME 

and set analysis will be like this 

Sum({<NAME={'Cash'} >}Value)

[jeevays7]

Hi Vikas,

Thanks for your reply.

but i don't need to write condition for each dimension. it should be dynamic.

'Cash' is a hard coded value, i need to be automatically fetch this value from dimension value.

[vikasmahajan]

you can do this some thing like this post

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Cycle-dimensions-using-a-variable-butt...

Vikas