Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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)