topic Re: How to use Select in Field trigger for an AGGR calculated field? in QlikView

How to use Select in Field trigger for an AGGR calculated field?

jblomqvist — Fri, 09 Sep 2016 15:18:32 GMT

Hi all,

I have the following expression which creates a calculated list box:

=Aggr(Count(DISTINCT OrderID), ProductName)

I then have a sheet trigger based on above like this:

But it does not select in the list box as I thought it might.

Does anyone know how I can make this type of field selection work when someone opens the sheet please?

Re: How to use Select in Field trigger for an AGGR calculated field?

neelamsaroha157 — Fri, 09 Sep 2016 15:21:47 GMT

You can create this calculation in the Script and then use the column for selection in trigger

Re: How to use Select in Field trigger for an AGGR calculated field?

sunny_talwar — Fri, 09 Sep 2016 15:24:34 GMT

May be try like this:

Dimension

ProductName

Search String

='=Count(DISTINCT OrderID) = 259'

Re: How to use Select in Field trigger for an AGGR calculated field?

jblomqvist — Fri, 09 Sep 2016 15:29:43 GMT

Hi Sunny,

Just to explain this, is it because you have to evaluate the expression first?

Why do you have to use an equal again? (i.e. the equal outside the single quotes).

Re: How to use Select in Field trigger for an AGGR calculated field?

sunny_talwar — Fri, 09 Sep 2016 15:33:55 GMT

I am not 100% sure, but I think if you just use this =Count(DISTINCT OrderID) = 259 as your search string, it might work as well. But since I have never tried that, I wanted to give an expression which I was fairly confident would work. The idea is that everything within the single quotes is supplied as a search string for making selections in ProductName field.