topic Re: Simple Column Count for > and = '0' in App Development

Simple Column Count for > and = '0'

rossdickinson — Fri, 15 Nov 2024 22:39:06 GMT

Hi,

I have a column called 'DEP_TIME' in my data set. It is measured in minutes.

If the DEP_TIME is on time, it is equal to 0.

Else, the DEP_TIME is late and has a value greater than 0.

I am looking to calculate the proportion of records on time (with '0') expressed as a percentage of all records.

So, something like this:

(Count of 'late' = '0') / ((Count of 'late' = '0') + (Count of 'late' > '0')) * 100

I am not familiar with Qlik custom functions, so I could please use some help!

BrunPierre — Sat, 13 Aug 2022 10:46:22 GMT

Try this

COUNT({<DEP_TIME= {'0'}> } DEP_TIME) /

(COUNT({<DEP_TIME= {'0'}> } DEP_TIME) + COUNT({<DEP_TIME= {">0"}> } DEP_TIME) ) * 100

rossdickinson — Sat, 13 Aug 2022 09:30:35 GMT

Hey,

I tried using a similar function and the results for

COUNT({<DEP_TIME= {'0'}> } DEP_TIME) alsways returns as '0'. Which is not the case, most of the values in the column are actually '0'.

The format of '0' in the column is '0.00', not sure if that needs to changed?

BrunPierre — Sat, 13 Aug 2022 10:38:29 GMT

Then perhaps try the below or would you share the 'DEP_TIME' values

COUNT({<DEP_TIME= {'0.00'}> } DEP_TIME)

BrunPierre — Thu, 25 Aug 2022 14:06:17 GMT

@rossdickinson Is your question answered?

vinieme12 — Mon, 29 Aug 2022 01:07:46 GMT

You need to count on a field that identifies each row uniquely

example

=count( {<DEP_TIME={"0"}>}rowid) / count( {<DEP_TIME={">=0"}>}rowid)

or just

=count( {<DEP_TIME={"0"}>}rowid) / count(rowid)