topic Re: Set Analysis in QlikView

Set Analysis

c_latham — Fri, 13 Apr 2018 09:54:06 GMT

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!

pascos88 — Fri, 13 Apr 2018 09:59:46 GMT

Hi,

try with this

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

Chanty4u — Fri, 13 Apr 2018 10:00:05 GMT

try this

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

c_latham — Fri, 13 Apr 2018 10:04:52 GMT

Thank you very much!! This worked

Chanty4u — Fri, 13 Apr 2018 10:05:41 GMT

Nice have a nice day