topic Conditional column won't show unless all rows match in QlikView

Conditional column won't show unless all rows match

swearengen — Tue, 05 Apr 2022 14:42:01 GMT

More of an observation than a question, however if anyone has a workaround any insight would be appreciated. When I have a condition on a column it won't show unless all the rows match.

For example in the attached I have the column 'Product' set to show if the product contains the text 'Logo'. If I select 'AWC Logo Cap' - all good, Product column is visible. And if I select 'All Purpose Bike Stand' the Product column disappears.

Here's my issue. If I select both 'AWC Logo Cap' and 'All Purpose Bike Stand' the column fails to appear. Wouldn't it make more sense for a column to appear if any rows in the selection match? Or am I missing something? Thx

Re: Conditional column won't show unless all rows match

rwunderlich — Tue, 05 Apr 2022 16:40:59 GMT

The issue is that you have provided no direction on what to do with multiple results from your conditional expression.

Product like '*Logo*'

When you select three Product values, and the expression is true for one product and false for two products, what would the overall result be?

You need to add an aggregation function to capture the "true" value.

Min(Product like '*Logo*' )

I used Min() rather than Max() because true is -1.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Conditional column won't show unless all rows match

swearengen — Wed, 06 Apr 2022 07:16:54 GMT

Perfect. Thanks Rob.