topic Re: Regarding max() function in the list box expression in QlikView

Regarding max() function in the list box expression

skiruthigadevi — Wed, 23 May 2018 16:53:12 GMT

Hi Friends,

I appreciate your time. Below is my scenario, could you kindly let me know your valuable thoughts on the same.

I need to display sales weight in a list box selection only if max(weight indicator) is 1.

my metrics display is from data island.

I have attached the sample document and metrics display excel where the metrics are from data island.

Thanks,

Kiruthiga

sunny_talwar — Wed, 23 May 2018 16:55:55 GMT

May be this?

=if(Max(TOTAL weight_ind)=0,if(_vWeighted=0,_MetricName),_MetricName)

skiruthigadevi — Wed, 23 May 2018 18:13:43 GMT

Hello Sunny,

Thanks a lot, much appreciate your time.It worked!!