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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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