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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
Contributor III
Contributor III

Set Analysis

Hi All,

I have the current expression to show orders per day:

Count([%Order ID]) / Count(Distinct O_Headers.ORDERDATE)

Which returns the value 81

I need to exclude any selections so that when someone selects an order ID (or any other field for that matter) that this value does not change.

I tried: =Count({$<[%Order ID]=>}[%Order ID]) / Count(Distinct{$<OHeaders.ORDERDATE=>}[%Order ID])

to remove the Order ID selection but the number drops to 76 (No Order ID has been selected at any point).

Can someone please point me in the right direction?

Thanks!

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

Count({1}[%Order ID]) / Count(Distinct {1}O_Headers.ORDERDATE)

View solution in original post

4 Replies
pascos88
Creator II
Creator II

Hi,

try with this

Count({1<[%Order ID]=>}[%Order ID]) / Count(Distinct{1<OHeaders.ORDERDATE=>}[%Order ID])



Chanty4u
MVP
MVP

try this

Count({1}[%Order ID]) / Count(Distinct {1}O_Headers.ORDERDATE)

c_latham
Contributor III
Contributor III
Author

Thank you very much!! This worked

Chanty4u
MVP
MVP

Nice have a nice day