Default filter

[#1]

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]

Hi bertybert,

This is what you are looking for I think

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Pre...

I have also attached the file below

Hope this helps,

Thanks

Tom

[jagan]

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]

Hi ,

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

Hope its useful for u.

Regards,

Iyyappan.

[#5]

Thank,

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

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