Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggregation with set analysis issue

Hi All!

I hope i can get you to understand my issue,

got a table containing the following fields:

ID, StationID ,Date, Box, Active

i need to present a number counting how many StationsIDs are following these rules:

1. Box= Yes

2. Active= Yes

3. Date= (last max value, already got this from a different table, can call id Max_date..)

3. Date= in last year

I am having issues combining all of these together trying to use Aggr and set expressions..


  {$<Date = {"Year to Date"}, Active={"Yes"}, Box={"Yes"}}>} 


Will appreciate any help!

1 Reply

Provide sample app or dummy data.