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: 
zied_ahmed1
Specialist
Specialist

Set analysis

Hello,

I have this KPI :

Count(doc)

and i need to this condition to have just the number of docs who have values >30  :

if(num(num#(interval(Field2-Field1,'mm'),'###'))>30)

how to do this with set analysis

Thanks

1 Solution

Accepted Solutions
sunny_talwar

How about this

Count(DISTINCT {<doc = {"=Num#(Interval(Field2 - Field1, 'mm'),'###') >30"}>} doc)

View solution in original post

1 Reply
sunny_talwar

How about this

Count(DISTINCT {<doc = {"=Num#(Interval(Field2 - Field1, 'mm'),'###') >30"}>} doc)