Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Advanced Set analysis

Hi all,

I need to calculate Count of contract numbers and have applied set expressions.

Count(DISTINCT{<Contract_number = {"=$(=Num(MonthEnd(Max(Date)))) - Max({<YearName=,Month=>}Intimation_Date) >=120  "},Intimation_Date = {"<=$(=Max(Intimation_Date))"}>}Contract_number),

How can i apply condition in area Highlighted as in need it to be in between 120-150 days not jus >=120 how and where can i write

=<150 in same expression

(Contract_number = {"=$(=Num(MonthEnd(Max(Date)))) - Max({<YearName=,Month=>}Intimation_Date) >=120  "})

2 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

I think like Set analysis sum between two given dates

Count(DISTINCT{<Contract_number = {"=$(=Num(MonthEnd(Max(Date)))) - Max({<YearName=,Month=>}Intimation_Date) >=120<=150  "},Intimation_Date = {"<=$(=Max(Intimation_Date))"}>}Contract_number)

Not applicable
Author

Hi ,

tried (>=120<=150) Its returning 0 value ,ideally it should not