How to Count ??

[Iamsoul69]

Dear All Expert in Qlik Sense,

      I have a table this, 

      I would like to Count TIME that > 30 minute ( Time come form END-START) 

and 

If I need to set a transaction that over 30 munite is "OutTime" and not over 30 munite si "InTime" in Master Messure, How the fx that I can use, 

Thankyou for all Support, 

ESoul

[sbaro_bd]

Hi @Iamsoul69 ,

Create a TIME dimension in script and associated it to a flag  : 

IF(TIME > 30,'OutTime','InTime') as Flag

 And then : 

Count(IF(Flag='OutTime',Flag))

 Regards.