topic How to sort values in a column if values are time in QlikView

How to sort values in a column if values are time

Fri, 15 Jun 2012 20:18:48 GMT

I have a table with these columns:

Date (mm/dd/yyyy)

Time (hh:mm:ss)

Queue (plain text)

Count (integer)

I am trying to sort the table by time. Also, i need to retrieve the earliest time where the count != 0, among other things. IS there an expression that I can use in order to retrieve this information. I would try to display this in a table box or any other apporpriate sheet object. Did I mention that I am a beginner at Qlikview as I just started using this about 3 days ago? I have tried expressions like if((Queue), if(Count>0, Time = Min(Time))) and other related expressions.

Any help or ideas would be appreciated.

Re: How to sort values in a column if values are time

Anonymous — Mon, 18 Jun 2012 04:02:05 GMT

Hi,

To pull the lowest Time value where the Count field is larger than 0, you could use the following expression:

=minstring({$<Count={">0"}>} Time)

Re: How to sort values in a column if values are time

Mon, 18 Jun 2012 12:39:13 GMT

Please, can you explain what the statement means? I am not exactly sure what it is saying. Also, I am just looking to pull the very first time in the table the table where the count is greater than 0. Is there some kind of looping function in Qlikview so I could loop thru the times until I find the very first time that fits the criteria? Thanks.