Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

Dimension value in a modifier

Hi All,

The below is the data source table:

ClassValue
Fx100
Fx200
Cash50
Cash50
Equity250

 

Now i need to show table like below:

NAMEValue
Fx300
Cash100
Commodity0
Equity250
Others0

 

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

3 Replies
vikasmahajan
Esteemed Contributor

Re: Dimension value in a modifier

While loading data in your script  change Class to NAME 

 

and set analysis will be like this 

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

Partner
Partner

Re: Dimension value in a modifier

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
Esteemed Contributor

Re: Dimension value in a modifier