Need Help with Set Analysis

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

I am looking for some help with a set analysis.

I have the current headers:

Load

Document Type

Document Number

Assignment

Posting Date

Reference

Text

Year-Period

OrderLookup

Payment

Accrual

I essentially need to get a sum of payments and accruals.

[Payments] happen on multiple [Posting Date]s, same with [Accruals].

Here is my problem. When I select a [Posting Date] as a filter, my Sum of [Payments] and [Accruals] are no longer accurate.

I need to select the [Posting Date] to find which [Load]s are effecting. Once I figure out which [Load]s, I need the sum of [Payments] on that specific [Posting Date], but I also need the sum of the [Accruals] regardless of date for those specific [Loads].

I am trying to do a set analysis with no success. Any help is greatly appreciated.

Re: Need Help with Set Analysis

vishsaggi — Wed, 20 Jun 2018 21:56:01 GMT

can you share a sample file to look into?

Re: Need Help with Set Analysis

sunny_talwar — Thu, 21 Jun 2018 01:34:20 GMT

May be this

Sum(Payments) + Sum({<[Posting Date], Loads = p(Loads)>}Accruals)

topic Re: Need Help with Set Analysis in QlikView

Need Help with Set Analysis

Re: Need Help with Set Analysis

Re: Need Help with Set Analysis