topic Re: Working expression in chart to display as concat expression in Text Field in QlikView

Working expression in chart to display as concat expression in Text Field

spikenaylor1 — Mon, 27 Nov 2023 15:16:17 GMT

I have a working expression in my straight chart table.

I have data set of Batches with upto 12 sublots in each batch

For a selection of batches

my expression is =If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID])

This displays the [SubLot ID] where the Opaque% >= OpaqueAlert,

I would like to display this as a concat text expression.

something along the lines of:

=Concat(If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID]))

so my straight table gives me these sublots which meet the expression for the select batches.

I would like to display this as a text object like C28, B75 (Distinct from C28, B75, C28, B75, C28, B75)

struggling to get my head around what is required.

marcus_sommer — Mon, 27 Nov 2023 15:51:18 GMT

A nesting of aggregations is only possible by defining the appropriate dimensional context by an aggr() function, like:

Concat(aggr(If(Avg(Total <[SubLot ID]> Opaque%) >= OpaqueAlert,[SubLot ID]), Dim1, Dim2))

whereby Dim1 and Dim2 are just placeholder for needed dimensions - usually the ones used within the chart.

spikenaylor1 — Mon, 27 Nov 2023 16:20:19 GMT

Many thanks,

works a treat