extension of a set expression

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm new at the community and are going about to make my first Projekt with set expressions. I've got the basic understanding of the set expressions. The problem ist, when I try to make an expression with a little bit more complexity.

For example:

There is a time line and i wanna know from a specific time X, whats the next available date, that is smaller than time X.

The time stamps beloging to products and one product has severall timestamps, that are in the historie table

time X

-----------------I--------------I------------>

max(Date)<X

I tried it like this:

1) count({<Date={'<timeX'}>}GGN) this Expression works fine, but gives out all possible Dates that are smaller than X

2) I need to add in to 1) a max statement, so that only the biggest date will be selected or maybe there is some other solution

Thank's up forward for the help

Re: extension of a set expression

sunny_talwar — Thu, 27 Oct 2016 16:32:48 GMT

May be try this:

Count({<GGN = {"=Max(Date) < timeX"}>} GGN)

topic extension of a set expression in QlikView

extension of a set expression

Re: extension of a set expression