6 Replies Latest reply: Nov 30, 2012 4:23 AM by sandston

To count amount of records that corresponds to date

I would like to know how I would go about producing within Qlikview the image below.

My data set has records for each day ranging from 40 - 250 (for both arrivals and departures) The details shown below are for departures only so an If statement would definitely need to be constructed.

If date and if departure count each record output total count. this would then be displayed as Total Mvnts, I have a column called Delay Mins already within Qlikview which calculates the difference between two time sets, I then want Qlikview to count each record that has a delay min of anything equal to or greater than 15.

I have attached the data file I am working from, I am unable to load files as I am using the personal free edition, so please can any advice be advised through here. Thanks

• Re: To count amount of records that corresponds to date

could you extend :

SCH -

ACT -

CHKS -

?

• Re: To count amount of records that corresponds to date

What do you mean sorry?

• Re: To count amount of records that corresponds to date

never mind:)

try to prepare table like:

dimension : DATE

expression 1 : =count(if(DelayMin>=15,1))

expression 2 : =count(DelayMin)

expression 3 : =Column(1)/Column(2)    (and set it yo %)

• Re: To count amount of records that corresponds to date

or do it by set analysis

dimension : DATE

expression 1 : =count({\$<DelayMin={">15"}>}DelayMin)

expression 2 : =count(DelayMin)

expression 3 : =Column(1)/Column(2)    (and set it yo %)

• Re: To count amount of records that corresponds to date

Hi thanks for the response I tried using the expressions you gave but it wasnt populating the correct result.

I then tried to write another statement: =(Count(if(sum(CHKS-SCH)*24*60>15)))

but again didnt populate the right answer the image in my first post has the correct values.

• Re: To count amount of records that corresponds to date

Hi I managed to figure out the correct formula,

=count(if((CHKS-SCH)*24*60>=15,1))

Thanks for you help