Aggr in calculated dimension

[#1]

Hi guys!

I've a problem in qlikview. I hope you help me!

I want to create a dimension from  a custom calendar. I only want to show some dates instead of all of dates of custom calendar.I thought in AGGR function and I used it :

=Aggr(Calendar.Week >= 40,Calendar.Week)

, to obtain all weeks older than week number 40, but doesn't work =(

Someone has idea about how to get this?

Thank you very much!

Regards!

[teempi]

Hi,

Can't you use set analysis in your expression instead of making a calculated dimension (which can be very slow) with aggr (which can also be slow).

For example something like Sum( {< Calendar.Week={">=40"} >} somevalue)

-Teemu

[MK_QSL]

=IF(Calendar.Week >= 40,Calendar.Week)

[#4]

Thanks Teemu,

It has been useful for me!

Regards!