Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vidyasagar159
Creator II
Creator 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

Labels (1)
0 Replies