Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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