Skip to main content
Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
phongnnguyen
Contributor II
Contributor II

Ignore selection for Dimension in If statement

Hello guys,

I have a problem with my expression. I wanna ignore filter with Date in if statement which Date is dimension.

I'm filtering TradeDate='01/01/2018' My expression is:

only({<TradeDate=>}TradeDate) => It's not work

other expression: aggr({<TradeDate=>}TradeDate,AccountID)  its result is 01/01/2018. But I wanna result show all list TradeDate in this case. It means my purpose is show all list data of TradeDate from Min date to Max Date .


Thanks for your help

1 Reply
ogautier62
Specialist II
Specialist II

may be this :

aggr(only({<TradeDate=>} TradeDate),TradeDate)