Dimension to be restricted

[helen_pip]

Dear Qlikview user

I have a date field called MonthYear which currently has data from Apr-14-Sep-16

I was wondering what would be the most efficient way of restricting the dimension on the X axis of my graph to only show data from

Apr-15 - Sep 16?

Could anyone point me in the right direction?

Kind Regards

Helen

[miguelbraga]

Hey there,

The most efficient way is by inserting a WHERE clause where you define from your start date in this case 01/04/2016 and the end date is 30/09/2016 if your date is in the following format 'DD/MM/YYYY'. Other way arround this is to apply a set analysis like this:

{<OrderDate= {">=$(=min(StartDate))<=$(=max(EndDate))"}> }

Best regards,

Data Architect MB

[Clever_Anjos]

Change your expression using Set Analysis

SUM({<MonthYear ={">=Apr-15 <=Sep 16"}>}Value) 

Please use exactly the same number format used into MonthYear

[sinanozdemir]

Hi,

Have you tried set analysis?

Sum({<Your_Dimension={">=$(=Date(MakeDate(2015, 4, 1), 'MMM-YY'))<=$(=Date(MakeDate(2016, 9, 1), 'MMM-YY'))"}>} Your_Measure)