topic Re: Force Selection in Set Analysis in QlikView

Force Selection in Set Analysis

cranium144 — Sat, 16 Nov 2024 04:49:36 GMT

Good day. I'm attempting to force a field selection with Set Analysis. The field is [Past Due], and the selection is "PD". Then I'm wanting to sum up the open orders (field [SO Open Qty]). Here is what I have.

The goal is to have this as a Dimension on a pivot.

=Sum({$<[Past Due]={$(=Only('PD'))}>} [SO Open Qty])

In my expression for this pivot, I'm doing the math to see where I go negative by day. Like this:

OH - RangeSum(Before(sum([SO Open Qty]),0, ColumnNo())) - (insert the Past Due syntax here)

Any help would be appreciated.

Re: Force Selection in Set Analysis

sunny_talwar — Tue, 08 Jan 2019 14:14:52 GMT

Try this

RangeSum(Before(Sum({<[Past Due] = {'PD'}>} [SO Open Qty]), 0, ColumnNo()))

Re: Force Selection in Set Analysis

cranium144 — Tue, 08 Jan 2019 15:01:58 GMT

=sum({<[Past Due] = {'PD'}>} [SO Open Qty])

I tried the above to start, but it doesn’t appear to be paying attention to the forced ‘PD’ selection. It’s returning zero. If I select dates in the past, then it gives an answer.

Re: Force Selection in Set Analysis

sunny_talwar — Tue, 08 Jan 2019 15:24:43 GMT

Would you be able to share a sample to show the issue?