Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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.

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

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:

=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

You can give this a shot as well:

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



Best,

S