Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)