Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
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