Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arsalanam
Creator
Creator

Expression As A Filter

I have an expression on front-end as:

=Round(Avg(if((ToDate - InitialDate)+1 > 0, (ToDate - InitialDate)+1)))

Both of them are coming form two separate QVDs.

Now, I need to provide user with an option to filter on this. In other words, how could I have above result set in a list box so they can filter on it?

1 Reply
khadeer_sparks
Specialist
Specialist

Hi,

If ur data is filtering in Datamodel, you can easily filter in frontend through list box.

In listbox general tab... field.... goto last u get expression option, u can write same expression there. It will work.

Hope it helps u

Regards,

Khadeer