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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
girish21595
Partner - Contributor III
Partner - Contributor III

Calendar selection is not excluding in the formula

Hi All,

Please check the below expression. In this I have excluded the Year, Month and Date Selections in Set Analysis. But it is not working. Could someone please let me know if I have to specify the exclusion elsewhere in the expression.

 

Sum({<[Year=, Month=, Date=>}Aggr(If([First Hearing Session Date] < (vMinDate) and
([Judgement Date] >= (vMinDate) or [Judgement Date] = 'NA') and
not match(

//Variable Start
Aggr(FirstSortedValue(distinct{<[Session Date] = {"<$(=Min(Date))"}, Year=, Month=, Date =,
[Session Type] = {'Val1','Val2'}>}
[Type], -[Session Date]),[Case ID])
//Variable End

,'v1','v2','v3','v4') and
(Status <> '2'),1,0),[Case ID]))

 

 

or is there a way to compare result of a variable(which will alter based on selection) with set of values in set analysis?

eg : Sum({<$(vTypeVariable) = {'t1','t2'}>}Sales)

 

Thanks,

Girish

0 Replies