topic Expression As A Filter in QlikView

Expression As A Filter

Anonymous — Wed, 22 May 2013 14:41:23 GMT

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?

Re: Expression As A Filter

khadeer — Wed, 22 May 2013 15:13:44 GMT

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