Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If statement with 2 conditions .

Hello everybody , I need to write an if statement with multiple conditions for example :

if(enter_time+exit_time) >= 2, count(vhcls) .

is there an if formula to do this or should I use another function?

many thanx.

Labels (1)
10 Replies
cmorri1988
Creator
Creator

Hi there,

I would create field in the script for this:


New_field:

LOAD

enter_time+exit_time as duration

FROM...

and use this measure:

Count(if((duration) >= 2,vhcls)

Hope this helps