Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Jérôme5625
Creator
Creator

Set analysis with OR and AND

Hello, 

i would like to create a set analysis with combinaison with one OR and one AND. 

the syntax is wrong.

Could you help me?

Count({<([ZOFSUIVI_V.390.autoCalendar.Date]={">01/01/2020"}+[ZOFSUIVI_OR.390]={'>01/01/2020'}),([ZOFSUIVI_R.595.autoCalendar.Date]={">01/01/2020"})>} [equipement])

thanks for advance.

Jérôme

Labels (2)
3 Replies
anat
Master
Master

seems correct

Count({<([ZOFSUIVI_V.390.autoCalendar.Date]={">01/01/2020"}+[ZOFSUIVI_OR.390]={">01/01/2020"}),([ZOFSUIVI_R.595.autoCalendar.Date]={">01/01/2020"})>} [equipement])

anat
Master
Master

seems correct

Count({<([ZOFSUIVI_V.390.autoCalendar.Date]={">01/01/2020"}+[ZOFSUIVI_OR.390]={">01/01/2020"}),([ZOFSUIVI_R.595.autoCalendar.Date]={">01/01/2020"})>} [equipement])

brunobertels
Master
Master

hi 

may be this 

Count({<([ZOFSUIVI_V.390.autoCalendar.Date]={">01/01/2020"}>+<[ZOFSUIVI_OR.390]={">01/01/2020"}),([ZOFSUIVI_R.595.autoCalendar.Date]={">01/01/2020"})>} [equipement])

AND : 

{<A={1} , B={5}>}

OR : 

{<A={1}> + <B={5}>}