Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
JuMo
Contributor III
Contributor III

How to make a COunt If, when month is smaller tha a given month

Hello

I want to make a count If for flags, If flag has been received before a given month

The following one is OK, but that's not what I want
Count({<[Global Date]=10>}[FLAG])

This one is not working
Count({<[Global Date]<=10>}[FLAG])

Neither this one
Count({<Month([Global Date])=10>}[FLAG])

And of course nor this one
Count({<Month([Global Date])<=10>}[FLAG])

What shall I do ?

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

script:

LOAD

     Month(Date) as Month,

     Num(Month(Date)) as MonthNum,

     

 

in front end

count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)

View solution in original post

2 Replies
Chanty4u
MVP
MVP

try this

script:

LOAD

     Month(Date) as Month,

     Num(Month(Date)) as MonthNum,

     

 

in front end

count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)

JuMo
Contributor III
Contributor III
Author

Thank you, it workds, however, I don't undertand why the characters in green here:

count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)