topic Re: Greater than Duration Filter in QlikView

Greater than Duration Filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a lot of data where the event is avtive for a duration of time, I would like to create a function where i can look at the data "raw" and then select events where duration is greater than 30 seconds, 1 minute etc.

The column total downtime is the sum of duration, i would like to be able to show this sum for events where i have chosen the greater than 30 seconds etc.

Relativley new so not too experienced with detailed script.

Re: Greater than Duration Filter

Gysbert_Wassenaar — Tue, 06 Dec 2016 13:34:29 GMT

Change the expressions to filter out the items you don't want: sum({<Text={"=sum([down time])>30/86400"}>} [down time]). You could use a variable in an input box (or a slider object) to enter a number of seconds and use the variable instead of the fixed number 30: {<Text={"=sum([down time])>$(vMyVariable)/86400"}>}. Note: you'd need to add the {...} part to every expression in your straight table.

Re: Greater than Duration Filter

marcus_sommer — Tue, 06 Dec 2016 13:39:59 GMT

Another way could be to create a listbox with an expression like:

=class(aggr(sum([down time]), Text), $(vMyVariable))

and using the variable quite similar to Gysbert's suggestion.

- Marcus

Re: Greater than Duration Filter

Anonymous — Tue, 06 Dec 2016 13:50:02 GMT

The first solution works fine, i tried the variable idea but could not see where i should set this, however this will only be adjusted by me so the fixed intervall will be fine.

Thanks

Des