Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

How to eliminate a value if it's too much lower than the previus value?

Hello guys,

I've a problem with my DataBase and I need your help to solve it.

I would like to show the number of planes flying for a specific airline per minute, and in order to do that, I'm using the following expression:

 

=count({<DATA ={"$(=Date(Max(DATA),'DD/MM/YYYY'))"},NCIA={'AZU'}>}TAIL)

 

But due to a time issue with my database, sometimes I'm not receiving the accurate number and the output is almost reduced to zero.

brunolelli87_0-1616766277412.png

I'm expecting something like this:

brunolelli87_1-1616766686166.png

Basically, I'm wondering how to eliminate the values that are more than 50% lower than the previous value.

 

This is how my database looks like:

 

25/03/21;22:29;AZU;AZU4376;AT76;PR-AQQ;CNF;UDI;-19.1421;-47.5004;272;18025;255;0;0
25/03/21;22:29;AZU;AZU4167;A20N;PR-YRB;REC;MAO;-7.4615;-39.1616;281;36025;445;0;0
25/03/21;22:29;AZU;AZU4771;AT76;PR-AQR;VCP;JOI;-25.2657;-48.4467;182;17700;267;0;-512
25/03/21;22:29;AZU;AZU4352;A20N;PR-YYG;REC;SLZ;-5.9628;-37.9439;298;37975;434;0;0
25/03/21;22:29;AZU;AZU4412;A20N;PR-YYJ;CNF;VIX;-20.4233;-40.4963;99;4850;263;0;-1344

 

0 Replies