Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
tsoley9262
New 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 Reply
Highlighted
Partner
Partner

Re: Text Object

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