Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Max function

Vittore8_0-1589364607930.png

Hi,please tell me how I can use set analysis  to get the maximum count? Where the category is equal to Games and the year is equal to 2016!

Max({<Category='{Games}', launche={2016}>} Count) -- my version

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try something like this

count ({<
   Category={'Games'},
   launched= {">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}
    >} Count)

View solution in original post

1 Reply
Vegar
MVP
MVP

Try something like this

count ({<
   Category={'Games'},
   launched= {">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}
    >} Count)