Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
=IF(Calendar.Week >= 40,Calendar.Week)
Thanks Teemu,
It has been useful for me!
Regards!