topic Re: Filtering out blank values in QlikView

Filtering out blank values

Wed, 04 Feb 2015 23:16:03 GMT

Hello all,

I have been struggling with the best way to filter out blank values. In this report I am trying to measure the amount of time between a widget sale and reload time. This is what I am trying, but to no avail.

=Interval(max({$<widget1={'*'}>}PurchaseTime)-(vReloadTime),'hh:mm')

Any guidance would be great!

Re: Filtering out blank values

Oleg_Troyansky — Thu, 05 Feb 2015 00:47:29 GMT

if you are trying to filter out blank values in the field widget1, then you could use the following syntax:

=Interval(max({$<widget1={"=len(trim(widget1))>0"}>}PurchaseTime)-(vReloadTime),'hh:mm')

this search condition will only include widgets that have a value that's at least one character long.

Re: Filtering out blank values

sunny_talwar — Thu, 05 Feb 2015 01:01:01 GMT

You can give this a shot as well:

=Interval(max({$<widget1=p({<widget1 = {'*?'}>})>}PurchaseTime)-(vReloadTime),'hh:mm')

Best,