Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Variable Expansion for expression with SET ANALYSIS

Hi Everybody,

I tried to create a variable expansion for expression with SET ANALYSIS.

sum({< [Element Sequence]={$1} >} [Assay Value] * DMT)

/sum({< [Element Sequence]={$1} >} DMT)

*sum(DMT)/100

I need to pass a value to [Element Sequence] set.

Please, any ideas.

Thanks in advance!

Ricardo

Tags (2)
1 Reply
Not applicable

Re: Variable Expansion for expression with SET ANALYSIS

sum({$< [Element Sequence]={'1'} >} [Assay Value] * DMT)

/sum({$< [Element Sequence]={'1'} >} DMT)

*sum(DMT)/100