Only show values in list box with sales volume

[#1]

Hello,

I have a list box showing Product Descriptions. I would like to only show values in this list box that have an associated volume. I have tried the following in the <Expression> option of the field drop down, but it selects the 'Actual Volume' field as well when I use the 'Product Description' list box as a filter:

=if([Actual Volume]>'0',[Product Description])

Please can you advise?

Thank you,

Mel

[stigchel]

Please try to move the condition to a Set expression, I think it should be something like

Aggr(Only({<[Actual Volume]={'>0'}>} [Product Description]),[Product Description])

[#3]

Hi Piet,

Thanks very much for this - this appears to work well, however, when I make a selection, all other values in my list box disappear entirely, rather than 'greying out' as do my other list boxes. Do you know how to work around this?

Thank you

Mel

[stigchel · Accepted solution]

Hi Mel,

Sure, just expand the set analysis to disregard the selection, like this:

Aggr(Only({<[Actual Volume]={'>0'},[Product Description]=>} [Product Description]),[Product Description])

Regards,

Piet Hein

[stigchel]

Hi Mel,

Did this solve your issue or do you need more help? If this is solved, could you mark my answer correct? It will close the thread and help others to find solutions.

Regards,

Piet Hein

[#6]

That worked, thanks very much Piet!

[stigchel]

You're welcome!