Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Dividing Fields in Set Analysis

Hello Everyone,

I am trying to only grab ID's where the quotient of 2 associated fields is less than 25%. I am trying this, but can't seem to get it to work.

count({<field1 / field2 = {"<.245"}>}ID)

Any help would be much appreciated.

Thanks,

Ben

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Dividing Fields in Set Analysis

Try this:

count(if(field1 / field2 <0.245,ID))

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Dividing Fields in Set Analysis

Try this:

count(if(field1 / field2 <0.245,ID))

View solution in original post