topic Default filter in QlikView

Default filter

Tue, 14 Feb 2012 15:41:24 GMT

Hello,

it is possible to have a default filter in calculation of expression.

and it may be possible to change filter with a dimension?

oxtontom — Tue, 14 Feb 2012 16:42:18 GMT

Hi bertybert,

This is what you are looking for I think

I have also attached the file below

Hope this helps,

Thanks

Tom

jagan — Wed, 15 Feb 2012 05:52:01 GMT

Hi,

Default filter is possible in expression by

Example 1:

=Sum({<Year={2012}>} Sales)

Here in the above expression always the Year would be 2012.

Regards,

jagan.

v_iyyappan — Wed, 15 Feb 2012 06:33:49 GMT

Hi ,

I have three Year(2010,2011,2012). I Showed default Max(Year) ie(2012).

Hope its useful for u.

Regards,

Iyyappan.

Wed, 15 Feb 2012 08:16:41 GMT

Thank,

but we can't change year by filter in the report

Example we have 3 year (2010,2011,2013)