Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: if statement with time stamp

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".