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: 
Anonymous
Not applicable

Complicated Set analysis

Hi All,

I would like to have an set analysis with below criteria:


Startdate <= “20170101”

And (ClosedDate = ‘'19000101' or ClosedDate >= “20170101” )

And (T2Startdate2>= 20170101  and T2Startdate2 <='99991231') )


I make an expression as below but it is wrong...

Sum({$<Startdate ={"<20170101"},T2TransDate ={">20170101"} ,ClosedDate={"01/01/1900>=20170101"}>}  Amount)

Any idea on it?

Best Regards,

Louis


1 Solution

Accepted Solutions
kruppas78
Contributor III
Contributor III

Hallo Louis,

I think this should work:

SUM({<Startdate={"<=20170101"},CloseDate={">=20170101", "19000101"},T2Startdate2={">=20170101<='99991231'"}>}Amount)

Best Wishes

Stefan

View solution in original post

2 Replies
kruppas78
Contributor III
Contributor III

Hallo Louis,

I think this should work:

SUM({<Startdate={"<=20170101"},CloseDate={">=20170101", "19000101"},T2Startdate2={">=20170101<='99991231'"}>}Amount)

Best Wishes

Stefan

crusader_
Partner - Specialist
Partner - Specialist

Hi Louis,

Try below (giving everything is numbers and no need to format anything):

Sum( {<Startdate ={"<=20170101"}, ClosedDate ={">=20170101", "19000101"}, T2Startdate2={">=20170101<=99991231"}>} Amount)

Hope this helps.

//Andrei