Discussion Board for collaboration related to QlikView App Development.
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
You should create a new field as minute and then use that field for conditioning.
Load Minute(max_time) as minutes