Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

remyasujith17
New Contributor III

Set analysis

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.

2 Replies
MVP
MVP

Re: Set analysis

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

remyasujith17
New Contributor III

Re: Set analysis

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