Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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