Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Fred12
Contributor III
Contributor III

Create a rate

Hello, I got a table like that :

 

TABLE 1 

0

0

1

1

1

25

-3

 

I want a rate who give me the difference in percentage of line equal to 0 or 1 

 

I tried something like this :

I want have a rate like that :  count ( TABLE 1  > 1 ) / count ( TABLE 1)

 

thanks in advance

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

1 Reply
Lisa_P
Employee
Employee

Lisa_P_0-1676327840289.png