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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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

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

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