Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Help help, I'm New to Qlik Sense and I'm trying to only show rows in a table based on Age using NetWorkDays & today() but I keep receiving an error
Here's what I have
aggr(only({$<Order Date={"$((=Order Date (NetWorkDays(Order Date,today()) >15)"}>}Order Date))
Try this
Aggr(Only({$<[Order Date] = {"=NetWorkDays([Order Date], Today()) > 15)"}>} [Order Date]))
Thanks for the Reply Sunny, It's not working I'm receiving an error message
"Error in expression: Aggr takes at least 2 parameters"
My bad, try this if you are using this as a dimension or list box expression
Aggr(Only({$<[Order Date] = {"=NetWorkDays([Order Date], Today()) > 15)"}>} [Order Date]), [Order Date])
or this if this is an expression
Only({$<[Order Date] = {"=NetWorkDays([Order Date], Today()) > 15)"}>} [Order Date])
Sunny
I used both solutions you proposed still not working what am I doing wrong?
The first - returns all null
The second - returns an error "Invalid Dimension"
I've attached a file so you can see what I'm looking at
Thank you for all of your help
Try creating a table with OrderCreated as dimension and NetWorkDays(OrderCreated, Today()) as expression and share a snapshot of it
here you go