topic Aggr in calculated dimension in Qlik Learning Discussions

Aggr in calculated dimension

Mon, 17 Nov 2014 09:28:22 GMT

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!

Re: Aggr in calculated dimension

teempi — Mon, 17 Nov 2014 09:43:57 GMT

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

Re: Aggr in calculated dimension

MK_QSL — Mon, 17 Nov 2014 10:07:25 GMT

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

Re: Aggr in calculated dimension

Tue, 02 Dec 2014 11:38:18 GMT

Thanks Teemu,

It has been useful for me!

Regards!