topic Re: Display sales data as per VBUP.GBSTA in QlikView

Display sales data as per VBUP.GBSTA

geam1988 — Thu, 19 Jul 2018 09:18:08 GMT

Hallo i have following expressions,

if(_CURRENCY='EUR' , num(sum(VBAP.NETWR_EUR), '#.##0,00€'),num(sum(VBAP.NETWR_USD), '#.##0,00 Usd') )

for the expressions i have variable $(vED)

now i want to display the result as per VBUP.GBSTA = 'A','B' . i do not want to show VBUP.GBSTA = C.

I used following expressions

SUM ({< VBUP.GBSTA = {'A','B'} >} $(vED))

Sum ( {< VBUP.GBSTA = {'A','B'} >} if(_CURRENCY='EUR',num(sum(VBAP.NETWR_EUR), '#.##0,00€'),num(sum(VBAP.NETWR_USD), '#.##0,00 Usd')) )

but it is not working ... looking for suggestion...

BalaBhaskar_Qlik — Thu, 19 Jul 2018 10:48:58 GMT

May be this one:

If(_Currency = 'EUR', num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_EUR),'#.##0,00€') ,

num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_USD),'#.##0,00 Usd')

)

Peter_Cammaert — Thu, 19 Jul 2018 11:47:38 GMT

What do you mean by "...but it is not working"? There could be a 100 reasons for SAP stuff to fail.

Are you getting blanks? Null value results? Wrong value results? No results at all? Does your computer crash?

geam1988 — Thu, 19 Jul 2018 13:11:23 GMT

No value at all

Peter_Cammaert — Thu, 19 Jul 2018 14:14:32 GMT

Do you have a correct link between VBUP and VBAP?

Please post a (complete) screenshot of the Table Viewer. In QV Desktop, press Ctrl-T and use the Export Image button at the left side of the toolbar.

geam1988 — Thu, 19 Jul 2018 14:36:32 GMT

with this formula i got the result,

If(_Currency = 'EUR', num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_EUR),'#.##0,00€') ,

num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_USD),'#.##0,00 Usd')

)

BalaBhaskar_Qlik — Sat, 21 Jul 2018 09:14:54 GMT

If you got the result, Make it as Answered & please close this thread.