topic Re: Link Filter Criteria into Caption in QlikView

Link Filter Criteria into Caption

jmonroe918 — Tue, 04 Mar 2014 05:47:37 GMT

I have a container holding 3 text objects (TX100, TX101 & TX102). TX100 has the following expression:

=Count({<[CAPA.Status]-={'Closed'},
[CAPA.Division] = {'VST'}
>} [CAPA.CAPA No])

The other two text boxes have similar expressions, the common thread is the [CAPA.Division] = {'VST'}.

Is it possible to force the "VST' into the container's caption? That way when I change out the text boxes with different divisions, I don't have to retype the division's designation every time?

Thanks.

Jeff

Re: Link Filter Criteria into Caption

Tue, 04 Mar 2014 06:12:38 GMT

Did you tried using Only() function.

In my case I used something like : =only({<itemid={26}>}address) in the Title of a chart.

This will return me the Address Name of Itemid=26.

Is that what you are looking for?

Thanks,

Angad

Re: Link Filter Criteria into Caption

jmonroe918 — Tue, 04 Mar 2014 06:17:16 GMT

Angad:

What I have now in the container caption is "CAPA - VST".

I would like the 'VST' to match whatever is entered in the expression of the Text Object.

Thanks.

Jeff

Re: Link Filter Criteria into Caption

sunilkumarqv — Tue, 04 Mar 2014 06:21:21 GMT

try this

='Division '&FirstSortedValue(CAPA.Division,-Aggr(Count({<[CAPA.Division] = {'VST'}>}[CAPA.CAPA No]]),CAPA.Division))

Re: Link Filter Criteria into Caption

jmonroe918 — Tue, 04 Mar 2014 06:30:05 GMT

Sunil:

Sort of, Except I want it to depend on what is in the 3 text objects. I have 7 other containers on the page with data from different divisions.

Jeff