Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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