Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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