topic Re: Distinct value in the list box in QlikView

Distinct value in the list box

Wed, 10 Oct 2012 15:59:18 GMT

How to display distinct value in a list box?right now list box looks like

and in the script I am using below to populate the newtime field

time

(time#(log_time,'yyyyMMdd-hh:mm:ss'),'hh:mm') as newtime

log_time is a string field which looks like

20120927-09:05:01

20120927-09:05:02

20120927-09:05:03

is there a way list box can look like

newtime
09.05
09.06

swuehl — Wed, 10 Oct 2012 16:04:33 GMT

Try

time#(time(time#(log_time,'yyyyMMdd-hh:mm:ss'),'hh:mm'),'hh:mm') as newtime

erichshiino — Wed, 10 Oct 2012 16:14:10 GMT

You can also try this:

maketime( hour ( time#(log_time,'yyyyMMdd-hh:mm:ss') ), minute( time#(log_time,'yyyyMMdd-hh:mm:ss') ) as newtime

Regards,

Erich

Wed, 10 Oct 2012 16:14:56 GMT

thanks...