Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

extension of a set expression

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

1 Reply
sunny_talwar

May be try this:

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