Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Filtering out blank values

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.


Any guidance would be great!

Tags (3)
2 Replies
MVP & Luminary
MVP & Luminary

Re: Filtering out blank values

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


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

Re: Filtering out blank values

You can give this a shot as well:

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