topic Re: conditional display in QlikView

conditional display

Thu, 24 Jul 2014 14:16:22 GMT

I want to display al the reasons (reason_id)

where the product status is blocked.

I tried with the following expression, whitout succes..

=({<project_status={'blocked'}>}reason_id)

Any ideas how to do it correctly?

Kind regards,

Katleen

Thu, 24 Jul 2014 14:49:40 GMT

Set analysis can be used only with aggregation functions like

Only({<project_status={'blocked'}>}reason_id)

Else just try If

If(project_status='blocked',reason_id)

Thanks

MK_QSL — Thu, 24 Jul 2014 15:25:36 GMT

You should have any aggr function with set analysis...i.e. max, min, sum, avg, only etc.