topic Re: Field To Keep in QlikView

Field To Keep

k_burata — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Have his set analysis below where in I ignore all selection except [Payment Group] Field. Problem is I want [Payment Group] to be less than and not just equal to. How do I do it?

Thanks

RangeSum(above(sum({1< [Payment Group] = P([Payment Group]) >}[Payment Balance]),0,RowNo()))

Should be <= P([Payment Group])

Re: Field To Keep

ogautier62 — Wed, 29 Aug 2018 08:27:26 GMT

Hi,

what are your dimensions ?

rowno() put to 0 at each change of dimension,

try to display rowno() to see if it could be that

(for my example your formula works)

regards

Re: Field To Keep

k_burata — Wed, 29 Aug 2018 09:16:43 GMT

Hi Olivier,

Yes it does work but I want to make it less than or equal to (<=) P([Payment Group]) instead of equal to (=).

Regards

Re: Field To Keep

ogautier62 — Wed, 29 Aug 2018 09:30:28 GMT

ok,

so just use :

RangeSum(above(sum({1 }[Payment Balance]),0,RowNo()))

if your rows are sorted by Payment Group it will sum <=

Re: Field To Keep

marcus_sommer — Wed, 29 Aug 2018 11:04:28 GMT

I think it's not possible with p() but min/max might give you the desired view:

sum({1< [Payment Group] = {"<=$(=max([Payment Group]))"} >} [Payment Balance])

- Marcus