Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Tjstracks
Contributor
Contributor

Set Analysis Question - Networkdays, today() in A Table

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))

 

 

6 Replies
sunny_talwar

Try this

Aggr(Only({$<[Order Date] = {"=NetWorkDays([Order Date], Today()) > 15)"}>} [Order Date]))
Tjstracks
Contributor
Contributor
Author

Thanks for the Reply Sunny,  It's not working I'm receiving an error message

 

"Error in expression: Aggr takes at least 2 parameters"

sunny_talwar

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])
Tjstracks
Contributor
Contributor
Author

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 

sunny_talwar

Try creating a table with OrderCreated as dimension and NetWorkDays(OrderCreated, Today()) as expression and share a snapshot of it

Tjstracks
Contributor
Contributor
Author

here you go