Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.

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