topic Re: Set analysis in QlikView

Set analysis

Anonymous — Mon, 14 May 2018 08:03:04 GMT

Hi all,

I want calculate the cash value, the condition is

Fetch data from table VBRP , Where (VBELN) in VBAK equal (AUBEL) in VBRP, Filter out A from (RRREL), Get cash order (VGBEL), Exclude duplicate cash orders.
Pass the cash sales order number received from (VGBEL) in VBRP to VBELN in VBAK, fetch Net value from field "NETWR" in VBAK, the sum of this Net Value is Cash value.

Re: Set analysis

petter — Mon, 14 May 2018 10:40:37 GMT

Can you please clarify what is tables, columns/fields and literal strings and values here?

Re: Set analysis

Anonymous — Tue, 15 May 2018 05:12:53 GMT

Table VBRP

Fields RRREL, AUBEL, VGBEL.

first have to filter out "A" from the field RRREL.

next avoid duplicates from the field VGBEL.

This VGBEL should match with VBLEN in another table VBAK

Cash value is sum(NETWR) in table VBAK