if statement with time stamp

rdsuperlike — Sat, 05 Aug 2017 00:51:46 GMT

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

Re: if statement with time stamp

kaushiknsolanki — Sat, 05 Aug 2017 08:06:20 GMT

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

topic if statement with time stamp in QlikView

if statement with time stamp

Re: if statement with time stamp