Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
SIGN UP for Qlik's 15-week Applied Data Analytics using Qlik Sense course. Begins May 9, 2022.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr in calculated dimension

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!

3 Replies
teempi
Partner
Partner

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
MVP
MVP

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

Not applicable
Author

Thanks Teemu,

It has been useful for me!

Regards!

Community Browser