Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vidyasagar159
Contributor II

Set Analysis filter is not working as Expected

Hello All,

Please help me with the below logic. I want to see the aggregation ranged values in set analysis including Null values for one Manager called 'ABC'. Here is the expression

Avg({-<ProductMetricsAtAgeZero={'?*'}>+<ProductMetricsAtAgeZero={'>=$(vmin)'}>*<ProductMetricsAtAgeZero={'<=$(vmax)'},[Manager Name]={'ABC'}>} Metrics)

However, when I am calling this Manager within Set Analysis it's not working. But when I am selecting the same product from the filter pane I am getting the right results. What am I doing wrong here?

 

Thanks,

-Vidya