Calculated Dimension in a Drill down group not working as expected
i have this issue with time drill down group. I created a simple bar chart with YEAR, MONTH and DAY as a drill down group. But i have about 100 years of data, so i just want to limit this to only recent 5 yrs data. So, in the drill down group for all the 3 fields, i added a calculated condition. Here, the functionality is little unexpected. But, when i have no calculation condition and just the fields as it is, it is working fine.
Please look at the app and do select the YEAR 2012 and APR in both the charts and see the difference.
i want to limit my dimension in a drill down group.For example i choose options in drill down group , 120 records are coming but i want to limit top 30 records.Is there any method about limiting number of records dynamicly in Qliksense ? It could be in drill down group or what else.