Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

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

Re: Set analysis

How about this

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

1 Reply

Re: Set analysis

How about this

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

Community Browser