Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tsoley9262
Contributor III
Contributor III

Text Object

I am creating a text object using the following code '=Num(Count(if(State = 'ONLINE'and ID ='s',1.0)),'#.##%')', it is showing me 2800.00% and I am trying to get it o be 100.00% when all the fields show ONLINE.

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

you are getting a count. so it will never be 100% unless the count value is 1

you should change your code to

count(Online condition)/count(totalnumber) with your number formatting

View solution in original post

1 Reply
dilipranjith
Partner
Partner

you are getting a count. so it will never be 100% unless the count value is 1

you should change your code to

count(Online condition)/count(totalnumber) with your number formatting

View solution in original post