Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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.

sample.png

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

1 Solution

Accepted Solutions
Not applicable

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

6 Replies
Not applicable

Re: To count amount of records that corresponds to date

could you extend :

SCH -

ACT -

CHKS -

?

Not applicable

Re: To count amount of records that corresponds to date

What do you mean sorry?

Not applicable

Re: To count amount of records that corresponds to date

never mindSmiley Happy

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 %)

Not applicable

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 %)

Not applicable

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.

Not applicable

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

Community Browser