Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

if statement with time stamp

I have defined a field as below in my script:

timestamp(max_time,'hh:mm:ss') as "Status%max_time",

i want to write if condition with max_time categorized  as <5 mins, >=5 mins to <=20 mins and >20 mins. Not sure how to categorize this timestamp value. Can someone help?

eventually want to create charts with above 3 categories with various dimensions

Thanks in advance

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You should create a new field as minute and then use that field for conditioning.

Load Minute(max_time) as minutes

From xyz;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!