calculated Date dimension field in straight table in qliksense

[andrea0901]

Hi Experts,

I need to get only the 2022 data from jan to till date in a Date filed which is  a dimension in my straight table. 

i have written the logic in Date dimension as 

=aggr(only({<Date = {">=$(=Yearstart(Max(Date),-3))<=$(=max(Today()))"}>}>}Date),Date)

and showing the result as

but in the chart it is displaying as hyphen as shown below:

Please assist me on this. Thank you in advance

[vinieme12]

Ideally you should be restricting the measures

Calculated Dimension for Jan to Date

=aggr(

only({<

Date = {">=$(=Date(Yearstart(Max(Date))))<=$(=date(max(Today()))) " }

>}  Date)       //  You have extra closing brackets here >} >} 

,Date)

Best to restrict in measures

Count({<Date = {">=$(=Date(Yearstart(Max(Date))))<=$(=date(max(Today())))  " } ,City={'Tokyo'} >}Distinct Customer)

[andrea0901]

hi , As i dont have a measure field , we just pulled all the fields as a dimension in a straight table. and i need to put in date dimension only. i have removed the extra brackets but didnt work