Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi I managed to figure out the correct formula,
=count(if((CHKS-SCH)*24*60>=15,1))
Thanks for you help
could you extend :
SCH -
ACT -
CHKS -
?
What do you mean sorry?
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 %)
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 %)
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.
Hi I managed to figure out the correct formula,
=count(if((CHKS-SCH)*24*60>=15,1))
Thanks for you help